Thread: Range question
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
strataguru[_19_] strataguru[_19_] is offline
external usenet poster
 
Posts: 1
Default Range question


Hi,

I'd like to select a Range in column 1 from Row 1 to 7. Another tim
it may be some other random column for a difference range of rows.

So I'm wondering - how can I numerically select a range. I can't us
hard coded values like:

Range("A1:A7").Select

How can I select my Range dynamically for a ad-hoc group of cells?

Thanks in advanc

--
stratagur
-----------------------------------------------------------------------
strataguru's Profile: http://www.excelforum.com/member.php...nfo&userid=131
View this thread: http://www.excelforum.com/showthread.php?threadid=26337