Sub findbottom()
ActiveSheet.Cells(Rows.Count, 1).End(xlUp) _
.Offset(1, 0).Select
End Sub


Gord Dibben MS Excel MVP

On Sat, 29 Apr 2006 11:52:01 -0700, Richard
wrote:

Yes, the first blank cell, sorry!

"Peo Sjoblom" wrote:

Do you really mean last as opposed to first so if you have data in A1:A10
and the first blank cell is A11 you want to go to A65536?

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"Richard" wrote in message
...
I have a CommandButton1 on Sheet1. I'd like to tell it, once clicked to go
to the last Blank cell in Sheet1 Column A. Thanks in advance!