View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carim Carim is offline
external usenet poster
 
Posts: 510
Default Hidden Range Names

Hello André,

Take a look at the solution in following post :
http://groups.google.com/group/micro...7ec85c0c714eb7

HTH
Cheers
Carim


wrote:
Hi, I am experiencing some difficulty with what appear to be hidden
range names in my workbooks. I am copying a sheet in the same workbook
and keep getting the message that range in the destination sheet
already exist. I then have to press the Yes button or redefine the
names, which takes a lot of time.
What is really frustrating me is that the range names cannot be seen
anywhere on the sheet or in the range name list under
INSERTNAMEDEFINE
Can anyone help me in clearing the names please?