ran1
=offset($a$1,1,0,counta($a:$a),1)
ran2
=offset(ran1,0,1)
Then, you may never have to change again

I would probably name then colA and colB

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Sanford Lefkowitz" wrote in
message ...
I have a large number of range names such as
ran1 referring to a1:a200
ran2; referring to b2:b200
down to about ran40
I want to change all of these so they go down 300 rows instead of 200
rows.

Is there any way I can do all these at once? Or do I Have to do them one
at
a time.

Thanks
Sanford