Dave,

I found this page in MSDN which looked hopeful,
http://msdn.microsoft.com/library/de...HV01049962.asp

Even though it was for XL2003, it stated that '... This topic lists all
constants in the Microsoft Excel object model ...'

But, <lol< guess what. xlDown isn't directly listed here., as it lists the
enumerations, so you need to know that xlDown is a member of xlDirection, to
expand that. Don't you dare say ... told you so ... <vbg

Bob


"davegb" wrote in message
ups.com...
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!