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에서 복구됨