Advertisement
ASP_Volume3 Microsoft Office Apps/VBA #65100

Column Name Excel

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 恢复