How to go from column-number to column-letter?

[GeneralDisarray]

Question about converting from column number to column letter:

I have a column number captured, k from:

Please Login or Register  to view this content.

And later in my routine I want to enter the Letter for k....

For example, if k represents column#3 i would like to get the letter C...

Seems like there should be a canned method for this, is there?

[GeneralDisarray]

Ok, this is exactly what I'm doing for the time being:

Please Login or Register  to view this content.

I'm having to carry the letter around in another variable, can i get away without that?

[jaslake]

Hi GeneralDisarray

Here's a Function that does just that

Please Login or Register  to view this content.

[GeneralDisarray]

:D thank you sir, just what the doctor ordered

[egonomist]

more easy, for all version Excel:

k= myRange.find(what:="text").column
x = Split(Cells(1, k).Address, "$")(1)

[GeneralDisarray]

cool, i'll test that one also.

I actually can get away without it (turns out). I was having trouble with statments like the following (where i is the row number and j the column number).

Please Login or Register  to view this content.

but i finally realized what i was passing in and just switched it to:

Please Login or Register  to view this content.

That worked just fine