Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I am working in an Excel Spreadsheet that is used as a template and has about 30 page. I am revamping it and sometimes when I try to copy a worksheet within the workbook, I get an error such as: "A formula or sheet you want to move or copy contains the name '\P' which already exists on the destination worksheet. Do you want to use this version of the name?" o To use the name as defined in the destination sheet, click Yes o To rename the range referred to in the formula or worksheet, click No, and enter a new name in the Name Conflict dialog box. I have no clue what this means. I built the template and it is used by a few other people but I am not sure how this got into my workbook. I don't recall ever naming ranges. When I copy and cell and hit F3, I get a very long list of Paste Names. I am including them all below because I don't know if they are unique to my spreadsheet or if someone can decipher what they mean. They are separated by the comma. \P, \PP, _1, _2, _3, _34536 , _346, _4, _5, _6, _7, A, asdf, asdfaf, B, dfdgfh, FY4_, IFN, NvsElapsedTime, NvsEndTime, PED, PER, s, SFD_HH_GL_CENTER, SFV_HH_GL_CENTER, W, Year My questions a What do they mean? Can I get rid of them? Should I get rid of them? How do I get rid of them? Any feedback is greatly appreciated. Thank you in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel copy/paste questions | Excel Discussion (Misc queries) | |||
Answers to questions posing more questions in a workbook | Excel Worksheet Functions | |||
View Questions and Answer to questions I created | Excel Discussion (Misc queries) | |||
Data delete and mass copy/paste with macro questions | Excel Programming | |||
Some questions on copy/paste in excel 97 | Excel Discussion (Misc queries) |