Cells returns a range object and from there you can select the entire column

cells(1,1).entirecolumn

HTH

"Hal Styli" wrote:

Hello

Can someone please tell me how to access a whole column using cells().

For instance range("a1") =cells(1,1), what is the cells equivalent of
range("a:a")?

Thanks in advance.
--
Hal