Go To last blank cell

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

[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


"Richard" <[email protected]> wrote in message
news:[email protected]...
>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!

[Richard]

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" <[email protected]> wrote in message
> news:[email protected]...
> >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!
>
>
>

[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


"Richard" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
>> news:[email protected]...
>> >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!
>>
>>
>>

[Gord Dibben]

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 <[email protected]>
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" <[email protected]> wrote in message
>> news:[email protected]...
>> >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!
>>
>>
>>