Get the Letter Value of a Colm from activecell.column?

mikezcg · #1 (**permalink**) 03-30-04, 14:23

i have some code that lands me in a certain colm. How can i get the Column letter, from my activecell location?

ie : activecell.column =1 is col A

?

MikeTheBike · #2 (**permalink**) 04-01-04, 07:23

Try

ColLetter = Mid(ActiveCell.Address, 2, 1)

ActiveCell.Address returns the address in $A$! format, therefore you need to look at positio 2

Hope this is what you want

MTB

mikezcg · #3 (**permalink**) 04-01-04, 08:40

Perrrrrfect,

Tnks

Internet Services

Web Development

Digital Marketing

Consumer Tech