Hi all,

Has anyone experience of the following problem I have, and more importantly willing to share how to solve, or at least give me an explanation of what is happening.

I have a very large workbook with multiple sheets. When trying to copy a sheet and place within the workbook I get the folling appear in a dialogue box:-


A formula or sheet you want to move or copy contains the name "awef" which already exists on the destination sheet. Do you want to use this version of the name?


This message appears for a number of names not just 'awef'.

Not matter what I reply Yes or No when I try to locate the named range via
insert-
name-
define-

I can see no sign of it / them.

Anyone have any thoughts on this please,

many thanks for any assistance,


John