Column References in Macros

  • Thread starter Brendan Vassallo
  • Start date
B

Brendan Vassallo

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
 
H

Harald Staff

Hi Brendan

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

HTH. Best wishes Harald
 
B

Brendan Vassallo

Thanks heaps Harald!!!!

Harald Staff said:
Hi Brendan

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

HTH. Best wishes Harald
Click to expand...
 
Top