Resize Dynamic Ranges

[Frank Kabel]

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.