Thread: Getting a subrange of a specified range.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
y y is offline
external usenet poster
  
Posts: 60
Default Getting a subrange of a specified range.
How can I get a subrange of a range?
Or simply a row or a column?

I'm looking for a trick like this

Supposing rng1= $A$3:$G$56

rng2=GetSubRng(rng1,2,2,4,3) <<

rng2 will be equal to $B$4:$D$7

Thanks Alex.

Reply With QuoteReply With Quote