Macro help (last row)

[Guest]

Hello: I have recorded a macro to do a certain function everyday. The
column formatting for the macro is the same everyday but the number of rows
that it contains may differ from day to day. I do not know how to do visual
basic and have recorded the macro by doing the functions needed. The problem
is that it records where to start deleting the rows just from that one days
file and I need it to be shorter or longer depending on the number of rows
there are in the file for that day. Can you please help?

 

[Anne Troy]

Try this: http://vbaexpress.com/kb/getarticle.php?kb_id=417
************
Anne Troy
www.OfficeArticles.com

 

[Bob Phillips]

You can get the last row in column A with

iLastRow = Cells(Rows.Count,"A").End(xlUp).Row