Resize Dynamic Ranges
 

Hi
try
rng1.resize(rng2.rows.count,rng2.columns.count)

-----Original 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
.