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