Get Column Letter of Active Cell in VBA
On Saturday, July 31, 2010 9:31:10 AM UTC-7, MIG wrote:
For some reason, activecell.column returns a number, where as
range.select requires a string.
So it's not possible to, say, select a range based on returning the
current column, or is it?
Is there a way of either
a) returning the column letter or
b) selecting a range based on column number?
Thanks.
Here ya go
MyCol = Columns(ActiveCell.Column).Address
this will return a result of $A:$A or whatever column you have active.
|