Dunno who Marsha is {g} but for all my criticism of MS's commitment (or
lack thereof) to good help for Office products, one should keep in mind
that the scope of the programming environment -- not just language --
is simply vast. As much as I would like to see everything documented,
I also recognize the enormity of the task. [As an aside, if you think
Office 2000 help is bad wait until you see 2003.]

Of course, I might not consider the problem you face as severe because
intrinsically I'm a lazy person and between the XL macro recorder and
VBE's intellisense capability I care little about things like syntax
and such.

About the only time I want to know the value of a mnemonic is when I'm
coding in an environment where the editor is unaware of XL (in another
Office app w/o setting a reference to XL or in VBS which doesn't
support the capability). In such cases, I create the code in XL, paste
into the other editor and replace unknown mnemonics with constants.
The easiest way to find the value of a mnemonic is the Immediate window
in the parent application. For example, ?xlDown in the XL VBE's
immediate window will give you the value associated with it. Then, in
the other editor adding 'Const xlDown as Long ={whatever}' or 'Const
xlDown ={whatever}' (as appropriate) means the rest of the code can
remain untouched.

As far as a book goes, I could be wrong but I suspect it will be a
fruitless search. Hard to imagine any publisher willing to commit
dozens (hundreds?) of pages to a seemingly endless list of constants.
Especially since that list should grow with each subsequent version of
the product. Personally, for things like this I find
msdn.microsoft.com far more rewarding; though I have to admit that at
times it too can be very frustrating.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article . com,
says...
Thanks, Marsha! At least I know that someone has attempted to address
this problem! Unfortunately, I'm stuck with XL2000, and VBA help
doesn't even recognize xlDown. After reading your reply, I went into
help and looked up Constants, which was mostly more confusing, but at
least there, and End Property, which was a little brief but helpful. I
just wish I could have found it without having to go online and ask and
wait for a reply.
I've been looking on Amazon for a book that might have more info on
this kind of thing (for XL2000), but didn't find anything that looked
promising. I just made an appointment with myself to head over to the
Tattered Cover bookstore (huge bookstore here in Denver) this weekend
and look at everything they have. Got to be something better than what
I'm doing now. I can't remember ever in my 57 years having so much
trouble finding good reference materials for something like a
programming language! Seems to me, MS should have created help with
every object, property, method, function, constant, etc defined at the
very least. I guess they don't see any direct profit in making their
product easier to use.
If I find any good reference manuals, I'll list them here.
Thanks again!