Tweak Code "change the column number to column letter" in Macro

[capson]

Is it possible to change the column number to column letter in the code below.

Thanks

Please Login or Register  to view this content.

[Norie]

You can convert the column number to a letter but you might not need to, depends what you are going to do with the letter.

Please Login or Register  to view this content.

[MickG]

Try:-

Please Login or Register  to view this content.

Even more Spooky !!!!

[jaslake]

Or this

Please Login or Register  to view this content.

[shg]

Another way, though I can't imagine why you need it:

Please Login or Register  to view this content.

[capson]

Thank you All, lots of ways to choose from, again thank you all

[jaslake]

You're welcome...glad I could help. Thanks for the Rep.