Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COPYING FORMULA CONTAINING NAMES/RELATIVE RANGE NAMES | Excel Discussion (Misc queries) | |||
Range Names | Excel Worksheet Functions | |||
Selecting range in list of range names depending on a cell informa | Excel Discussion (Misc queries) | |||
range names | Excel Worksheet Functions | |||
range names | Excel Worksheet Functions |