PDA

View Full Version : Solved: named range issue



drawworkhome
12-12-2009, 04:09 PM
hi all, i have a workbook that i copy to a folder in its entirety. my code goes along with. part of my code lists all named ranges in column v.
in the copied workbook tho, a named range that used to be called "aa!$8:$8" now comes up #REF!$8:$8 and breaks my code. any suggestions or general ideas?
thank you
erik

mikerickson
12-12-2009, 04:26 PM
aa is a poor name for a sheet, since there is a column AA.

drawworkhome
12-12-2009, 04:30 PM
it is a named range, not a sheet. however your point is in general valid.

mikerickson
12-12-2009, 04:50 PM
"aa!8:8" is the Name of a range, not the RefersTo ?!?!

If that's the case, I'm surprised it didn't fall over before this.

drawworkhome
12-12-2009, 04:58 PM
seemed to work just fine till i decided to copy the workbook for the user to use. the intent is to "initialize" an area of a sheet that information is going to be written to. the user then types in whatever they deem necessary to call this item. in this particular case, it is for estimating use so it is a "line item". this initialized value then changes to the cell value and then the intent was to change the initialized named range to the new value. then i delete the old named range.
erik

mikerickson
12-12-2009, 05:26 PM
Just to keep my mind straight, I'm not going to continue with this thread.
I'll be confining myself to the cross-post at
http://www.mrexcel.com/forum/showthread.php?t=435704