By using listi.net you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

listi.net

ActiveCell.Address

The address property can return the A1 formatted address

Immediate Window

? activecell.Address
$A$400

You can use the Split function to get the row and columns

Immediate Window

a = split("$A$400","$")
for i = lbound(a) to ubound(a):? "a(" & i & ")= ",a(i):next
a(0)=
a(1)=         A
a(2)=         400