What is _1 ? Garyntx 12/18/2008 3:57:00 PM 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.

RE: What is _1 ? Barb Reinhardt 12/18/2008 10:22:01 PM 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. -- HTH, Barb Reinhardt If this post was helpful to you, please click YES below. "Garyntx" wrote: [Quoted Text] > 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.