Range("D1", Range("D1").End(xlDown)).Select


--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Rick" wrote in message
...
I need to modify a column of data, but am having trouble determining how to
select all of the column, up until and including the last row.

I have tried this formula below, but it is not doing what I thought it
should....

Range("D:D", Range("D:D").End(xlDown)).Select

Any help is appreciated.

Ric