Thread: Select last blank cell in a range of data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DJ Dusty[_2_] DJ Dusty[_2_] is offline
external usenet poster
  
Posts: 1
Default Select last blank cell in a range of data

Hi,

During the running of my macro, I want the macro to be able to select
the first blank cell it comes to, at the bottom of a list of data.

So, if cells A1:A12 contained data, then I'd want cell A13 to be
selected by the macro.

Any ideas? Must be an easy one for some of you!


--
DJ Dusty
------------------------------------------------------------------------
DJ Dusty's Profile: http://www.excelforum.com/member.php...o&userid=16335
View this thread: http://www.excelforum.com/showthread...hreadid=520077

Reply With QuoteReply With Quote