Hi
try
=rng1.offset(1,1).resize(4,3)

--
Regards
Frank Kabel
Frankfurt, Germany

"y" schrieb im Newsbeitrag
...
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.