Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Blank (empty) cell always equal to 0?? | Excel Discussion (Misc queries) | |||
Return of blank cell if lookup fails | Excel Worksheet Functions | |||
Setting Purely BLANK Cell | Excel Worksheet Functions | |||
Replace null string with blank cell | Excel Discussion (Misc queries) | |||
Look for change next blank cell in Range | Excel Worksheet Functions |