If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
range names
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 |
#2
|
|||
|
|||
range names
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 |
Thread Tools | |
Display Modes | |
|
|