我如何获取单元格的列字母(需要使其通过Z列，例如AA，AB) [英] How can i get the Column letters of a cell (need to make it work past the Z column such as AA,AB)

问题描述

可能重复:
将列号转换为字母的VBA函数?

Possible Duplicate:
VBA function to convert column number to letter?

我想让Z列后面有列字母， 有很多技术可以在Z列之前获取它，但是在Z列之后似乎没有任何作用 有办法吗?

I want to have the column letters past the Z column, there are many techniques for getting it before Z column but after Z, nothing seems to work Is there a way to do so?

推荐答案

另一种方法:

Public Function ColumnLettersFromRange(rInput As Range) As String

    ColumnLettersFromRange = Split(rInput.Address, "$")(1)

End Function

这篇关于我如何获取单元格的列字母(需要使其通过Z列，例如AA，AB)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！