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

948 Steps to 6 Figures by Learning Excel-VBA and Other Skills



Step 264 - 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


    •    Table of Contents | Send us your feedback | © 2025 All Rights Reserved | Edit