View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
HBF[_2_] HBF[_2_] is offline
external usenet poster
 
Posts: 1
Default How do I identify a range based on cell value?


I have data sorted by a column. I want to loop down thru the column
until the value = "A". I want to name that cell somthing like "start
of A". Then I want to loop through the column until the last value =
"A", and name that "end of "A". Then I want to select the range "start
of A:end of A"

Thanks for your help


--
HBF
------------------------------------------------------------------------
HBF's Profile: http://www.excelforum.com/member.php...o&userid=34019
View this thread: http://www.excelforum.com/showthread...hreadid=552410