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,

Shawn

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

HTH

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

Stuart:

Works great!!! Thanks for your help bud!

Cheers,

Shawn