Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Excel 2003 SR2
I'm working through some VBA and save often to other worksheets. I have several named ranges (Rows1_5000, 5001-10000, etc). The range is from $A$1 to $K$5000. But I notice that ranges sometimes change to H or C in place of K. I have the $ in front of the row and column - I thought that would keep it defined as I wanted. How come it changes? What can I do to keep it the way I first defined it? It is very time consuming to continously check and change it. TIA, CaroleO |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
automatic range - named range give me circular reference... | Excel Discussion (Misc queries) | |||
Array as a "named range" - formula ok in cells, but error as "named range" | Excel Discussion (Misc queries) | |||
inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
formula for named cell/range using cell values | Excel Worksheet Functions | |||
Cannot Expand Named Range - when size of the Range exceeds | Excel Discussion (Misc queries) |