/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

0 vote249 views1 answer
Vba sort the data Z to A
VBA
0 vote256 views1 answer
Iterate all file in a folder vba
VBA
0 vote219 views1 answer
Add items to combobox vb.net
VBA
0 vote253 views1 answer
Excel vba set cell value to empty
VBA
1 vote226 views1 answer
Excel vba autofit
VBA
1 vote241 views1 answer
Vb.net get name by Cell Click
VBA
0 vote221 views1 answer
Refresh token em vb net
VBA
1 vote181 views1 answer
Ms access open form to new record
VBA
0 vote246 views1 answer
Excel vba protect scenarios
VBA
0 vote224 views1 answer
Excel vba disable mouse click
VBA

Share