Suppose in the range A1:A10 I have values that are the days of the week, but
cells A3 and A7 are blank. How do I write a VBA statement that will select
a range that includes all the values in column A (assuming there is no other
data in the worksheet)? I seem to remember there being an xlUp or xlDown
method, but I'm not sure of the syntax. If I'm not mistaken, there should
be a way to code it so that it will work for a list of any size.

Thanks for any suggestions!

-gk-