MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How to create a macro that moves to bottom of list?

Posted by Shawn on November 18, 2001 8:16 PM

I would appreciate any help creating a macro that would allow me to always move to the bottom of a list so that I can start entering new information. The new information would start on the next available row at the bottom of the list.

Thanks and cheers,


Posted by Stuart on November 18, 2001 9:13 PM

Try this, if the data starts in cell A1 and runs down the page:

Range("A1").End(xlDown).Select 'runs down the page to last entry
Selection.Offset(1,0).Select 'moves down 1 cell to next blank cell


Posted by SHAWN on November 19, 2001 7:05 AM


Works great!!! Thanks for your help bud!