Consider the following: I define the start and end of a range on one
worksheet (worksheet #1) by naming each and refer to the range on another
worksheet (worksheet #2) in a VLOOKUP function, with the notation
"name_start:name_end". I then copy both worksheets via "Edit, Move or Copy
Sheet" to a new workbook. In the new workbook, the VLOOKUP will use the
names referring to the starting workbook. In the new workbook, "Insert,
Name" will display the local names on "worksheet #1", but qualified by the
worksheet name on the right-hand side. On "worksheet #2" it will show the
names with the reference to the starting workbook. I'm looking for an easy
way to eliminate use of the names pointing to the starting workbook, and then
using the names pointing to the newer workbook--in the VLOOKUP function.
Simply deleting the names shown in "Insert, Name" on "worksheet #2" in the
newer workbook does not do the trick. I'm using MS Excel 2000.