Skip to content

Instantly share code, notes, and snippets.

@brazilnut2000

brazilnut2000/ColumnLetter

Created June 19, 2013 18:52
Show Gist options
  • Save brazilnut2000/5816887 to your computer and use it in GitHub Desktop.
Save brazilnut2000/5816887 to your computer and use it in GitHub Desktop.
Download ZIP
VBA: Returns the column letters for the column given.
Raw
ColumnLetter
Function ColumnLetter(colNum As Long) As String
Dim vArr
vArr = Split(Cells(1, colNum).Address(True, False), "$")
ColumnLetter = vArr(0)
End Function
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment