/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

7 votes355 views1 answer
Vba array declaration
VBA
0 vote336 views1 answer
Vbnet add axis labels to chart
VBA
0 vote323 views1 answer
Vba dropdown event
VBA
0 vote321 views1 answer
Vba sheet visible
VBA
0 vote373 views1 answer
Vbnet round to nearnest thousand
VBA
0 vote358 views1 answer
Excel vba urlmon
VBA
0 vote323 views1 answer
Visual stuiod not recognising desgined labels
VBA
1 vote345 views1 answer
Vb.net get name by Selection Changed
VBA
11 votes479 views1 answer
Excel vba How to URL encode a string
VBA
0 vote292 views1 answer
How to sort datagridview in vb.net
VBA

Share