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.
Bookmarks