Is that mail merge a mechanized routine or is manual?

If it's manual, do you refer to any data by the name -- instead of an address
(or sheet and address???).

In fact, you'll have to check any macro/mechanized routine for the same thing.



cardan wrote:

On Apr 20, 1:07 pm, Dave Peterson wrote:
I would spend some time with those names to see if they're actually used
anymore.

I thought (mis-remembered???) that names that look like /P are the names of the
old Lotus macros -- this /P would be started by using alt-shift-p. But it's
been a long time...

Get a copy of Jan Karel Pieterse's (with Charles Williams and Matthew Henson)
Name Manager:
NameManager.Zip fromhttp://www.oaltd.co.uk/mvp

You'll be able to look at each name and see if it's used in this workbook. But
be careful. The names could be used in code somewhere (I don't think that the
NameManager looks at the code.)

And it doesn't check to see if there are any other workbooks (anywhere in the
world!) that rely on a name in your workbook.

But you'll be able to see if the name was an experiment that wasn't cleaned up
like asdf, asdfaf.

You'll be able to clean up those names (there's a Delete button on that
userform).

Some of the other names look like there was thought behind them: NvsElapsedTime
and even _3. You'll want to be careful when checking these.

In fact, you may want to make a backup of the original file before you start --
and even save as a new name before anything that looks dangerous.



cardan wrote:

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.

--

Dave Peterson

I just realized I did not mention that this workbook is set up to do a
mail merge into a Word document. (I guess I spent too much focus
typing out the Paste Names). Would a mail merge be an issue? I will
download that zip to see what I can find out and let you know. Thank
you for the feedback.

--

Dave Peterson