Function numberToColumnName(ByVal colNumber As Integer) As String
Dim dividend As Integer
Dim columnName As String
Dim module As Integer
dividend = colNumber
While (dividend > 0)
module = (dividend - 1) Mod 26
columnName = Chr(65 + module) + columnName
dividend = (dividend - module) / 26
Wend
numberToColumnName = columnName
End Function
No hay comentarios:
Publicar un comentario