Goto last cell

[Martin B]

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

 

[Sandy Mann]

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).Select

--
HTH

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk


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