Column References in Macros
 

I am writing a Macro and want to referecne a column by using its A1 reference
(ie Column A etc) instead of its R1C1 reference.

I am using the activecell.column funtion at the moment. Is there any way to
get this to retun the A1 column reference?

Brendan

Column References in Macros
 

Hi Brendan

Sub test()
MsgBox ActiveCell.EntireColumn.Address(False, False, xlA1)
End Sub

HTH. Best wishes Harald

"Brendan Vassallo" skrev i
melding ...
I am writing a Macro and want to referecne a column by using its A1
reference
(ie Column A etc) instead of its R1C1 reference.

I am using the activecell.column funtion at the moment. Is there any way
to
get this to retun the A1 column reference?

Brendan

Column References in Macros
 

Thanks heaps Harald!!!!

"Harald Staff" wrote:

Hi Brendan

Sub test()
MsgBox ActiveCell.EntireColumn.Address(False, False, xlA1)
End Sub

HTH. Best wishes Harald

"Brendan Vassallo" skrev i
melding ...
I am writing a Macro and want to referecne a column by using its A1
reference
(ie Column A etc) instead of its R1C1 reference.

I am using the activecell.column funtion at the moment. Is there any way
to
get this to retun the A1 column reference?

Brendan