MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Simple Macro movement

Posted by Bob T on December 18, 2001 6:48 AM

Can you help this novice on macros? I am trying to create a very simple macro that finds the next empty cell in a list. How can I do this? Like End, Down, Down. The first row could read: Selection.End(xlDown).Select, but I don’t know the code for the next line "Down". Your help is greatly appreciated.

Posted by Russell Hauf on December 18, 2001 7:07 AM


will give you the blank cell.