VBA =SUM issues

I'm sure this has a very simple solution that I'm overlooking and/or overthinking. What is wrong with this vba formula?

[e8].Formula = "=sum(e2:" & [e2].End(xlDown) & ")"

I've tried a number of variations with Range and quotes. I gave up.

I'd actually like to sum "E2:E7" and go all the way down to column Z. The "E7", however, is variable. It may be "E3" on one workbook or "E100" on another. Is there a more elegant solution than VBA copy/pasting this all the way down?

Thank you.

FWIW:

Please Login or Register  to view this content.