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

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

will give you the blank cell.

HTH,

Russell