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 dont know the code for the next line "Down". Your help is greatly appreciated.

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

Selection.End(xlDown).Select
ActiveCell.Offset(1,0).Select

will give you the blank cell.

HTH,

Russell