Adapting recorded macro to different amount of rows

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

yetti - 12 Jan 2006 07:43 GMT

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.

Reply to this Message

Bob Phillips - 12 Jan 2006 09:10 GMT

Something like

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

Signature

HTH

Bob Phillips

(remove nothere from email address if mailing direct)

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

Reply to this Message

yetti - 13 Jan 2006 07:28 GMT

Your help is most appreciated thank you

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

Reply to this Message