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
|