Convert Column Number to Letter VBA

Hi All,

I believe this should be fairly simple, but i just cannot put my finger on what to do. I am trying to get a column number reference to be its corresponding letter.

Here is the chunk of my code, obviosly the highlighted part is not working properly as of right now because my column is being referenced as a number. Is there some easy way to go about changing this without using mod or anything else. I am looking for a quick fix. Thanks for any help.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Above will convert column number to letter. not my code...can't remember where i got it

you can also do:

Please Login or Register  to view this content.

Thank you all for the help, i ended up using vandans second post because it was less work, but i can see how both of yours help. Thanks again!

You don't need the column letter:

Please Login or Register  to view this content.

thanks for the info