Please find the following details about conversion from Column Number to Column Name in Excel VBA. Please find the following output, which is shown in the following screen shot.Ĭolumn Number to Column Name: By Referring Excel Range and Using SPLIT Function Output: Press ‘F5’ or click on Run button to run the above procedure. MsgBox 'Column Name is : ' & fnColumnToLetter_CellAdressReplace(105) And “105” represents the row number of ‘fnColumnToLetter_CellAdressReplace’ function parameter. In the below example ‘fnColumnToLetter_CellAdressReplace’ is a function name, which is written above. It will show you how to get column name from column number using Excel VBA. 'Easiest approach by Replacing a Cell addressįunction fnColumnToLetter_CellAdressReplace(ByVal ColumnNumber As Integer)įnColumnToLetter_CellAdressReplace = Replace(Replace(Cells(1, ColumnNumber).Address, '1', ''), '$', '')Ĭolumn Number to Column Name: Example and Output Column Number to Column Name: Using Recursive ApproachĬolumn Number to Column Name: Easiest Approach by Replacing a Cell Address.Column Number to Column Name: Using Chr Function and Do While loop.Column Number to Column Name: By Referring Excel Range and Using SPLIT Function.
