ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How to find hidden names on an Excel worksheet ? (https://www.excelbanter.com/excel-worksheet-functions/60180-how-find-hidden-names-excel-worksheet.html)

Jon Sipworth

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.

Dave Peterson

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

Jon Sipworth

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