Goto last cell
 

This is pretty simple but then again so am I

I have a macro which when run from a command button unhides all the hidden cells on a sheet.

What do I need to add to the end of the macro to place the cursor in the last cell in a column which has data in it?

Told you it was simple.

Thanks in anticipation
Martin

Goto last cell
 

You don't say which column so I will assume that it is the Column that the cursor is in:

Cells(Rows.Count,ActiveCell.Column).End(xlUp).Sele ct

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Martin B" wrote in message ...
This is pretty simple but then again so am I

I have a macro which when run from a command button unhides all the hidden cells on a sheet.

What do I need to add to the end of the macro to place the cursor in the last cell in a column which has data in it?

Told you it was simple.

Thanks in anticipation
Martin