activecell.formula with vba defined range

[aeewing]

I cant figure out what I'm doing wrong with this formula.

I am trying to insert a SUM formula for the hours1 range I have defined. Can anyone see what I'm doing wrong?

Please Login or Register  to view this content.

[ImStevenB]

I see you have defined the cell range for hours1 .. but not for hours.

[Richard Buttrey]

Hi,

Try instead

Please Login or Register  to view this content.

[aeewing]

Richard,

That worked, thanks!

Steve - thanks for the reply. The hours range is defined in the worksheet.