Simple formula in VBA problem

[JimM]

Hi
It's been a while since I've played with VBA and obviously much more rusty than I thought!
Trying to put a simple formula in a macro and it's not liking the syntax (highlights red in VBA editor) any ideas why

Range("E" & lastrow + 1).Formula = "=Sum(E2:E" & lastrow ")"

All I'm trying to do is select the cell after the last item in column E and add up that column (excluding the title)
Lastrow variable is working properly
Thanks

 

[Joe4]

You are missing an "&", i.e.
Range("E" & lastrow + 1).Formula = "=Sum(E2:E" & lastrow & ")"

 

[JimM]

Doh! Thanks for that, couldn't see it for looking!!

 

[Joe4]

You are welcome.
I have been there myself. Sometimes you stare at an issue for so long, you miss the obvious, and it is good to get a second set of eyes on it!
Glad I was able to help!