Cell Address split

[Vic Schoeman]

Good day everybody,
Please help me,
If the cell address is ("AA20"), please explain to me how I can split it into variables
VarOne = "AA"
VarTwo = "20"
Thank you and have a nice day
Vic

[johnjohns]

To find the Row Number

Please Login or Register  to view this content.

To find the Column Letter

Please Login or Register  to view this content.

Thanks to John Walkenbach for the later

[johnjohns]

Also see this link https://www.excelforum.com/showthread.php?t=733999

[Krishnakumar]

Hi,

In VBA

for Column

Please Login or Register  to view this content.

For Row, replace (0) with (1)

HTH