select copy paste into new book incrementing rows

  • Thread starter Thread starter mike
  • Start date Start date
M

mike

It's probably been asked a hundred times, but I am still having a hard time
figuring out based on going through others posts.

I need a range (say AA3:AB3) to be copied, another file to be opened (we can
call it Data.xls) and the range pasted into the next blank row and the file
closed. etc.

I'm having issues with the "next blank row" part of it. What's the easiest
way to achieve this?
 
There's enough there for me to get the job done.....Thanks! I should have
checked your stuff first.... =)
 
Next blank row in column A

Dim rng As Range
Set rng = Cells(Rows.Count, 1).End(xlUp).Offset(1, 0)


Gord Dibben MS Excel MVP
 
Back
Top