View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Richard
 
Posts: n/a
Default 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!