Advertisement
4_2005-2006 Microsoft Office Apps/VBA #170397

Column Name Excel

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

AI

Riepilogo 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.

Codice sorgente
original-source
Function ReturnName(ByVal num As Integer) As String
 ReturnName = Split(Cells(, num).Address, "$")(1)
End Function
Commenti originali (3)
Recuperato da Wayback Machine