Skip to main content

Posts

Showing posts with the label excel macro to show column name

Get Excel Column Name in excel sheet

Get Excel Column Name in excel sheet Just write in macro of excel in module this code Public Function ConvertToLetter(iCol As Integer) As String Dim columnName As String Dim modulo As Integer While iCol > 0 modulo = (iCol - 1) Mod 26 columnName = Chr(65 + modulo) + columnName iCol = Int((iCol - modulo) / 26) Wend ConvertToLetter = columnName End Function and call in your sheet