![]() |
How to find hidden names on an Excel worksheet ?
When I copy a worksheet to another workbook, it prompts that the worksheet
has several names already defined in the workbook. I look in "Insert" "Name" "Define" and see no names listed. These names must exist on the worksheet-- but I can't locate them. Can anyone point me in the direction to find these names? Thanks. |
How to find hidden names on an Excel worksheet ?
You could use Jan Karel Pieterse's (with Charles Williams and Matthew Henson)
Name Manager: You can find it at: NameManager.Zip from http://www.oaltd.co.uk/mvp Jon Sipworth wrote: When I copy a worksheet to another workbook, it prompts that the worksheet has several names already defined in the workbook. I look in "Insert" "Name" "Define" and see no names listed. These names must exist on the worksheet-- but I can't locate them. Can anyone point me in the direction to find these names? Thanks. -- Dave Peterson |
How to find hidden names on an Excel worksheet ?
Thanks. It looks very helpful.
Jon S "Dave Peterson" wrote: You could use Jan Karel Pieterse's (with Charles Williams and Matthew Henson) Name Manager: You can find it at: NameManager.Zip from http://www.oaltd.co.uk/mvp Jon Sipworth wrote: When I copy a worksheet to another workbook, it prompts that the worksheet has several names already defined in the workbook. I look in "Insert" "Name" "Define" and see no names listed. These names must exist on the worksheet-- but I can't locate them. Can anyone point me in the direction to find these names? Thanks. -- Dave Peterson |
All times are GMT +1. The time now is 02:39 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com