5_2007-2008 Microsoft Office Apps/VBA #192915

Column Name Excel

Name: Column Name Excel
Brand: Planet Source Code
SKU: PSC-192915
Availability: InStock
Rating: 4.5 (965 reviews)
Author: [Pieter]

[Pieter]

★★★★★

4.8 · Téléchargements: 2,341

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

Résumé par IA: 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.

Code source

Function ReturnName(ByVal num As Integer) As String
 ReturnName = Split(Cells(, num).Address, "$")(1)
End Function

Commentaires originaux (3)

Récupéré via Wayback Machine