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