Skip to content

Instantly share code, notes, and snippets.

@Se7enSquared

Se7enSquared/ReturnColumnLetter.vbs

Last active May 25, 2022 03:40
Show Gist options
  • Save Se7enSquared/eb3804650db23fdd9cf9f56b76ff0c91 to your computer and use it in GitHub Desktop.
Save Se7enSquared/eb3804650db23fdd9cf9f56b76ff0c91 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
ReturnColumnLetter.vbs
' ----------------------------------------------------------------
' Function: ReturnColumnLetter
' Purpose: Given a column number, returns the letter as a string
' Params: col_num: Integer: the column number to convert
' Author: Gray
' Date: 1/19/2021
' ----------------------------------------------------------------
Function ReturnColumnLetter(ByVal num As Integer) As String
ReturnName = Split(Cells(, num).Address, "$")(1)
End Function
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment