By using listi.net you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

listi.net

ColumnLetter - udf - converts a column # to a column letter

🔝
This UDF converts a column number to a letter. An example would be column 27 is AA.

The code I use is to do the following:

Pass in the column number

assign the .Column property from the Range("A" & lCol).column

Return the value