Jon,
I never thought of that one. Isn't it great that you can do the same thing
in so many different ways.

Don Guillett
SalesAid Software

"Jon Peltier" wrote in message
...
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.