Or, you could just make them dynamic where the second one depended on the
first
rng1=offset($A$2,0,0,counta($a:$a),4)
rng2=offset($h$2,0,0,counta($a:$a),4)
notice I changed the range from A to H but still counted rows in A.
--
Don Guillett
SalesAid Software

"VJ" wrote in message
...
I have two ranges rng1 and rng2. These are two dynamic ranges. I need to
resize the rng1 according to rng2.

How can I set the size of rng1 to rng2 through VBA code?

Looking for help.

Thanks