Sum in VBA not defined correctly

[Robert E Lee]

Hi All

I have tried the following code which does not complile and would be glad of some guidance.

ActiveCell = Application.WorksheetFunction = Sum(Range("F" & N + 2, "F" & R))

Thanks Rob

 

[steve the fish]

Its WorksheetFunction.Sum

 

[mole999]

isn't it Application.WorksheetFunction.Sum. can't test that from here

 

[Robert E Lee]

Thank you both, I haven't used VBA for about 10 years and am somewhat rusty

Rob