Or

rng2 = offset(rng1,0,7)

to make rng 2 the same size, offset by 7 columns (A to H)

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Don Guillett wrote:

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.