Solved: named range issue

[drawworkhome]

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]

aa is a poor name for a sheet, since there is a column AA.

[drawworkhome]

it is a named range, not a sheet. however your point is in general valid.

[mikerickson]

"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]

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]

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