Macro Formula

[Gary Smith]

Sorry if this is very basic, but could someone please tell
me how to move the cursor, at the end of a recorded macro
to the first empty cell in a column (in this case C)
Thanks, Gary

 

[Peo Sjoblom]

One way

Range("c:c").End(xlDown).Offset(1, 0).Select

 

[Gord Dibben]

Gary

Select first blank cell in Column C starting from top............

Columns(3).End(xlDown).Offset(1, 0).Select

First blank cell at bottom of column C..............

Cells(Rows.Count, 3).End(xlUp).Offset(1, 0).Select

Gord Dibben Excel MVP