VBA to return the Column LETTER NOT Number

I have the following code, used after searching through numerous forum articles, and this is STIll returning the column number, NOT the LETTER. I need the letter returned to store in a variable.

Can anyone advise me on how to get this to return the column LETTER rather than the number?

Please Login or Register  to view this content.

Thoughts Excel Peeps?

Example

Please Login or Register  to view this content.

jindon - THANK YOU THANK YOU THANK YOU, This is exactly what I was looking for. I never thought to try it through a function call. Works brilliantly.

SimeyC - Thank you as well, however your's did not work for my scenario.

You are welcome.

However, I'm not sure about what you are really trying to do though, you don't need to get the Col.Letter most of the cases.....

True, but I have Range code in another module that I will be using the variable in, global variable obviously!. So in the range code below, I will be replacing the :M with :"& ACol &", etc. this will be used in a number of different workbooks and the columns will not always be the same, so I needed a way to dynamically find the columns, this was the only way I could figure out.

Please Login or Register  to view this content.

will now be

Please Login or Register  to view this content.