Thread: Select Range
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson[_3_] Jim Thomlinson[_3_] is offline
external usenet poster
 
Posts: 983
Default Select Range

Ok you have lost me... Is the 300 a static number or should your question
have been Current C5 then Select C10 - C305... If the latter then try...

range(activecell.offset(5,0), activecell.offset(300, 0)).select

HTH

"Jodie" wrote:

How do I select the range that starts 5 cells below the current selection
down 300 cells. ie. Current cell c5 select C10:c300.
Thanks for your help, you guts are great!
Jodie