[mso] Re: Excel reserved names
- From: "Dian Chapman" <dian@xxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Mon, 22 Sep 2003 18:01:55 -0500
>The only answers I am getting seem to imply that there are no reserved
words. However, responses on another board suggest the following ideas:
Just a thought...but if you can't find WHAT the reserve names are, you might
try to save yourself from accidentally using them by using a naming
convention.
In Word, there are several words that you can't use in VBA cos' they are
command names or some such SPECIAL word that does something...so you can't
use them as words when selecting a name for a routine. Example, if you
wanted to create a custom command to print a single page, you can't use the
word Print...cos' that's a command and thing you don't expect might happen.
If you mean that there are some reserve names when naming ranges or
whatever, why not use a convention like rngMyRange for naming. In the case
with the Print command in Word, you can't use Print, but you can use myPrint
and it's fine. Just a thought.
Dian D. Chapman
Technical Consultant,
Microsoft MVP & Instructor
Free Tutorials: www.mousetrax.com/techtrax
Free Word Tips & Tricks eBook: www.mousetrax.com/books.html
Learn VBA the easy way, thru video! www.mousetrax.com/techcourses.html
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
Of Kathy Jacobs
Sent: Monday, September 22, 2003 3:29 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Excel reserved names
The only answers I am getting seem to imply that there are no reserved
words. However, responses on another board suggest the following ideas:
1) Hidden names for sheets
2) Illegal names (don't start with letter or underscore, no space, too =
long, or cell reference)
Are any of these the problem, by chance?
Kathryn Jacobs, Microsoft MVP PowerPoint Get PowerPoint answers at
http://www.powerpointanswers.com Cook anything outdoors with
http://www.outdoorcook.com
Kathy is a trainer, writer, Girl Scout, parent, and whatever else there = is
time for I believe life is meant to be lived. But:
if we live without making a difference, it makes no difference that we =
lived
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On = Behalf
Of Linda F. Johnson
Sent: Monday, September 22, 2003 1:23 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Excel reserved names
Glenn...I'm getting nowhere with this quest...can you tell me exactly = what
the name was that you tried to use? And is this name also the name of = one
of your sheets?=20
Linda F. Johnson, M.A., MOS
Linda's Computer Stop
http://personal-computer-tutor.com
Free e-Books, Newsletter, and tutorials
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx
with the word "unsubscribe" (without the quotes) in the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also
allow you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation
with instructions. Once you are a member of the files group, you can go
here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
