Range of a whole column in Cells syntax
 

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

Range of a whole column in Cells syntax
 

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

Range of a whole column in Cells syntax
 

Hi Hal

Cells are cells. Columns are columns. Rows are rows. Use
Columns(1)
as in
MsgBox Columns(1).Address

HTH. Best wishes Harald

"Hal Styli" skrev i melding
...
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