Go To last blank cell

R

Richard

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!
 
P

Peo Sjoblom

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
 
R

Richard

Yes, the first blank cell, sorry!

Peo Sjoblom said:
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
Click to expand...
 
P

Peo Sjoblom

Cells(Rows.Count, "A").End(xlUp).offset(1,0).Select

--

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
 
G

Gord Dibben

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


Gord Dibben MS Excel MVP
 
Top