Column Letter instead of number

Re: Column Letter instead of number

[vba]ColumnLetter = Replace(Cells(1, ColumnFind.Column).Address(0, 0), 1, "")[/vba]

Re: Column Letter instead of number

ColumnLetter = Mid("ABCDEFGHIJKLMNOPQRSTUVWXYZ", ColumnFind.Column, 1)

Re: Column Letter instead of number

Quote from brgipple

To all reading this, after i posted my thread another thread popped up at the top as a related link that i did not find in my search. this new thread had the answer that i was looking for.

ColumnLetter = Left(ColumnFind.Address(True, False), InStr(1, ColumnFind.Address(True, False), "$") - 1)

i didn't know about the 'ADDRESS' extension. Now i do, i LEARNED something today i can go home!

thanks for your time

brian.

Display More

Just shows the value of defining a good Thread Title. Glad you are sorted.

Re: Column Letter instead of number

Sure does. A few good matches under Simliar Thread too.