xlDown is just a constant which is used to tell the property. The
constants
will not be defined in help, that is anything starting with xl (for
Excel),
vb (for
VB), or mso (for Office), so you need to look at the 'thing'
that
the constatnt is being used with, probably the End property in this
case.
Look up End in help and you will see xlDown defined in there.
You need to use the old grey matter, and work some things out.
So by using my "gray matter", I could have figured out that xlDown is a
constant, which is used to tell the property? I don't see this as
simple inductive or deductive reasoning. You tell me that all I had to
intuitively know was that it is a constant, "probably with the End
property in this case". I disagree with you here, Bob. It's obvious to
you because you been doing it a while, but certainly not intuitive or
something one can "figure out" by using their "gray matter", at least
not until they've worked with VBA for a while.
Well at least you are happy :-).
Please, Bob, let's not get sarcastic. It won't help. I respect your
knowledge of VBA, and appreciate your help. But I am very frustrated
that the built in help assumes I have fairly extensive knowledge of the
inner workings of VBA. The help for VBA, at least in XL2000, is
intended for those knowledgeable in VBA. I'm only complaining that some
fairly obvious things could and should have been done by MS from the
beginning, and that it's frustrating for a beginner to try and ferret
them out. I don't think I'm being unreasonable. I've learned
programming languages before, albeit a long time ago, and always
started with a reference that at least had something on ALL the
commands, parameters, etc. Obviously, MS themselves have recognized the
problem as evidenced by the fact that the info I need is now in Help.
I believe they could have made this process much easier for me and
others by spending some additional time and effort on the Help file.