Macro help (last row)

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
You can get the last row in column A with

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