ホーム › 6_2008-2009 › Column Name Excel
Advertisement
6_2008-2009 Microsoft Office Apps/VBA #215433

Column Name Excel

[Pieter]
★★★★★
4.8 · ダウンロード数: 2,341

Returns the name of the column, given a number. Eg. 5 -> 'E', 50 -> 'AX'. One line of code!

AI

AIサマリー: This codebase represents a historical implementation of the logic described in the metadata. Our preservation engine analyzes the structure to provide context for modern developers.

ソースコード
original-source 
Function ReturnName(ByVal num As Integer) As String
 ReturnName = Split(Cells(, num).Address, "$")(1)
End Function
オリジナルのコメント (3)
Wayback Machineから復元