VBA Excel Auto Sub

[dprayner]

Hi good people.

I want to set up a formula in VBA to auto sum a column of amounts.

I have a for loop so that I can count the number of rows (which changes day to day). I set up the variable num to store the number of rows.

The beginning row is E3. What formula would I use to auto sum the column from E3 to E num?

DAVE

 

[PHV]

Perhaps this ?
yourRange.Formula = "=SUM(E3:E" & num)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886