Skip to content

Instantly share code, notes, and snippets.

@nobrinskii
Created March 16, 2012 05:28
Show Gist options
  • Save nobrinskii/2048651 to your computer and use it in GitHub Desktop.
Save nobrinskii/2048651 to your computer and use it in GitHub Desktop.
[vba/excel] 列番号から列を表すアルファベットを取得する
'-------------------------------------------------------------------------------
'列番号から列を表すアルファベットを取得する
'-------------------------------------------------------------------------------
'【引数】列番号
'【戻り値】列を表すアルファベットの文字列
'【備考】
Private Function GetColumnAlphabet(intColumnNumber As Integer) As String
Dim strTmp As String
strTmp = Cells(1, intColumnNumber).Address
GetColumnAlphabet = Replace(strTmp, "1", "")
End Function
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment