Advertisement
6_2008-2009 Microsoft Office Apps/VBA #215433

Column Name Excel

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

AI

Shrnutí 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.

Zdrojový kód
original-source
Function ReturnName(ByVal num As Integer) As String
 ReturnName = Split(Cells(, num).Address, "$")(1)
End Function
Původní komentáře (3)
Obnoveno z Wayback Machine