Function to convert column number to letter?

by

This function returns the column letter for a given column number.

Function Col_Letter(lngCol As Long) As String
    Dim vArr
    vArr = Split(Cells(1, lngCol).Address(True, False), "$")
    Col_Letter = vArr(0)
End Function

testing code for column 100

Sub Test()
    MsgBox Col_Letter(100)
End Sub

More Related Contents:

  1. Sequence of numbers based on start and end value of 2 cells [closed]
  2. How do I declare a global variable in VBA?
  3. How to use the Implements in Excel VBA
  4. VBA code doesn’t run when cell is changed by a formula
  5. What is the difference between dim and set in vba
  6. How to set recurring schedule for xlsm file using Windows Task Scheduler
  7. Change date format using substitute or replace
  8. Getting the actual usedrange
  9. Delete a row in Excel VBA
  10. VBA: Convert Text to Number
  11. Iterating through populated rows
  12. How can I run VBA code each time a cell gets its value changed by a formula?
  13. Using VBA to detect which decimal sign the computer is using
  14. Referencing Excel Userform Control Name Value From String (VBA)
  15. Loop through each row of a range in Excel
  16. Fill formula down till last row in column
  17. If string contains word from list, return value adjacent to list value
  18. Refreshing all the pivot tables in my excel workbook with a macro
  19. Countif With Multiple OR Criteria
  20. Vlookup to copy color of a cell
  21. excel vba freeze pane without select
  22. Converting a string representation of a constant into a constant?
  23. Macro to export MS Word tables to Excel sheets
  24. VBA WinHTTP to download file from password proteced https website
  25. Excel VBA – select multiple columns not in sequential order
  26. How to check whether certain sheets exist or not in Excel-VBA? [duplicate]
  27. Application.WorksheetFunction.Match method
  28. Excel – Using COUNTIF/COUNTIFS across multiple sheets/same column
  29. Delete all data rows from an Excel table (apart from the first)
  30. Excel telling me my blank cells aren’t blank

Leave a Comment