- ©«¤l
- 2035
- ¥DÃD
- 24
- ºëµØ
- 0
- ¿n¤À
- 2031
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- Office2010
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-3-22
- ³Ì«áµn¿ý
- 2024-2-1
|
¦^´_ 3# mave - Function ColumnName(Rng As Range)
- ColumnName = Split(Rng.AddressLocal, "$")(1)
- ' Rng.AddressLocal : "$AB$1" : String
- ' Split(Rng.AddressLocal, "$")(0) : "" : String
- ' Split(Rng.AddressLocal, "$")(1) : "AB" : String
- ' Split(Rng.AddressLocal, "$")(2) : "1" : String
- ' ColumnName : "AB" : Variant/String
- End Function
½Æ»s¥N½X |
|