Dynamic range

mg_reich

Board Regular
Joined
Jun 4, 2004
Messages
82
I'm sure the info that I need is in a post somewhere, but I can't seem to find what I'm looking for.

I need to copy a row consisting of 4 cells and paste to a dynamic list. I am basically looking for a way to write a macro that finds the end of the list and pastes there.

Any ideas?
Thanks.
 

Some videos you may like

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

mrhartley

Well-known Member
Joined
Mar 8, 2005
Messages
564
Hi, Is this any good to you?
Code:
Sub test()

Dim lastrow
lastrow = Range("A65536").End(xlUp).row
Range("A" & lastrow + 1).Select

End Sub
It will take you to the last empty row in your sheet. You can adapt it to work against other columns besides A and also to past with too.

Regards
Mark
 

mg_reich

Board Regular
Joined
Jun 4, 2004
Messages
82
No, I don't think that will work. There are multiple instances on one sheet. There are several lists on one sheet.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,821
Messages
5,574,515
Members
412,599
Latest member
Schu94
Top