xldown in a non-contiguous column
xlup
Set rng = cells(rows.count,1).End(xlup)
--
Regards,
Tom Ogilvy
"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?
|