/VBA/Excel vba column letter

Excel vba column letter

Excel vba function to convert column number to letter

Function ColName(n)
    ColName = Split(Cells(, n).Address, "$")(1)
End Function

31

Source: academy.excelhero.com

Excel vba column letter

Function ColumnLetter(pColIndex As Long) As String
    ColumnLetter = Replace(Cells(1, pColIndex).Address(True, False), "$1", "")
End Function

1

Similar codes

3 votes141 views1 answer
Extract the nth word from a text string
VBA
0 vote150 views1 answer
Vba change active sheet
VBA
0 vote154 views1 answer
Columns dont autoresize on program start vb.net
VBA
1 vote157 views1 answer
Vba optional
VBA
0 vote161 views1 answer
Excel vba protect scenarios
VBA
0 vote178 views1 answer
Vb ternary
VBA
8 votes164 views1 answer
Excel vba make integer
VBA
0 vote160 views1 answer
Excel vba set cell value to empty
VBA
0 vote147 views1 answer
Excel vba combine ranges
VBA
0 vote140 views1 answer
Enable macros on opening workbook vba
VBA

Share