Adapting recorded macro to different amount of rows

[yetti]

If you record a macro for a regular process but you do not know how many
rows of data will be needed each month how do you change script to cater for
say a total being needed at end of the last rows.

 

[Bob Phillips]

Something like

iLastRow = Cells(Rows.Count,"A").End(xlUp).Row
Cells(iLastRow+1,"A") = ... your sum formula

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[yetti]

Your help is most appreciated thank you