MACRO ADD ROW

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

Guest

I am trying to figure out how to create a macro that will add a row in the
proper place everytime. For ex. I have rows with months inputted. Every month
i would like to insert a row after the last month(A20) on the sheet and
insert the "next month"(A21) and then input data across the inserted row. The
problem then becomes the next month if I run the macro it will insert in a
new row after A20 when I need the row inserted after A21. Is there a way for
excel to know to go to the last Month in the row and insert a row.
 
You can use something like

LastRow = Cells(65536,1).end(xlup).row

to determine the last row on your worksheet and then add your new ro
below this

An alternative is to do something like

Cells(65536,1).end(xlup).offset(1,0) = NewMont
 
Back
Top