What is _1 ?

  • Thread starter Thread starter Garyntx
  • Start date Start date
G

Garyntx

I've had this workbook that always worked in 2003, but now when I try to copy
a worksheet in 2007 within this workbook I get the following error.

"A formula or sheet you want to move or copy contains a name ‘_1’, which
already exists on the destination worksheet.â€

How can I find these names and remove them or disable this?

Thanks in advance.
 
I'm guessing you're copying a worksheet from another workbook that had named
ranges in it. FWIW, it does this in 2003 as well.

I don't have 2007 handy, but I believe on the View tab, you can use the
name manager (it's in the middle of the ribbon) to view the named ranges in
the workbook.
 
Back
Top