My Daily Technical skills
NavigationBar
Home
PowerShell Scripts for Beginners
SQL Server Posts
Thursday, 13 February 2014
VBA function to convert column number to letter?
Function Col_Letter(lngCol As Long) As String
Dim vArr
vArr = Split(Cells(1, lngCol).Address(True, False), "$")
Col_Letter = vArr(0)
End Function
Sub Test()
MsgBox Col_Letter(100)
End Sub
Newer Post
Older Post
Home
About Me
Praveen kumar voruganti
View my complete profile