Go To last blank cell
 

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!

Go To last blank cell
 

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!

Go To last blank cell
 

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!

Go To last blank cell
 

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


"Richard" wrote in message
...
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!

Go To last blank cell
 

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!