I still don't know what xlDown does.

It doesn't do anything! It's just the representation of a number, ie a
constant, that's all. You could replace it with it's value -4121.

In a new Sub type the following (don't cut/paste)

Dim rng2 As Range
set rng2 = activecell.End(

When you get to the "(" you should see the choices available to you, one of
which is xlDown, and instructs "End" which direction to go.

Whenever you see xlEtc it's a constant, I think always a "Long" (what's a
Long ??)

Re your comments about VBA Help. It's best to treat this as a reference
manual with some examples. But it's not intended as a tutorial, yes some
errors and limitations. Having said that my own view is it is excellent.
Imagine sitting down and writing it from scratch, even with a team of 100.

In the above example select "End" and press F1. What more could you ask!

Regards,
Peter T

"davegb" wrote in message
ups.com...
I did as I promised and went to the Tattered Cover bookstore this
weekend, spent 30 min or so looking at every book they had on XL VBA,
from skinny "Dummies" books to huge tomes I could barely lift (I'm not
getting any younger). I even looked through the ones on newer versions
of XL than 2000, which I am working with here.
Not a single book listed in the index "xlDown". Or xlUp, or
xlDirection. I'm forced to conclude that the documentation on VBA is
limited, to put it kindly. I still don't know what xlDown does. will
have to try to intuit it from examples of code gleaned here. I have to
admit, this is difficult for me. I'm much better at understanding a
comcept, then seeing how it is applied, than the other way around. Just
the way my limited mind works. I guess I need the mental exercise!
Thanks for all the help. I'm still plugging.