Compile error expected expression help

[andrewdp3]

I'm not sure why but I keep getting the compile error expected expression -

sheets("Main").cells(currow,3).value= Sum('V Template (2)'!F4:F75)

Any ideas?

 

[VoG]

Try

Sheets("Main").Cells(currow, 3).Value = worksheetfunction.Sum(Sheets("V Template (2)").Range("F4:F75"))

 

[andrewdp3]

Thanks very much! Code worked great -