Hi - I have 2 questions:

1. I have dimmed and set a range like TestRange =("B:B,D:D,F:F,H:H").
How do I programmatically determine the last cell in the range that
contains data (as well as the address of this cell)?


2. In the same range above, I need a macro to load the data into a
dynamic array, say DynArray. The data in the range will all be integers.


Any help will be appreciated.
Thanks
Jay

*** Sent via Developersdex http://www.developersdex.com ***