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