xldown in a non-contiguous column
You bet. xlUp... try this...
dim rng as range
set rng = Sheets("Sheet1").Cells(rows.count, "A").end(xlUp)
msgbox rng.address
--
HTH...
Jim Thomlinson
"David Gerstman" wrote:
I have a non-contiguous column that I need to read. xldown will only take me
to the first blan row. Is there an alternative to xldown to get to the real
bottom of the column?
|