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

948 Steps to 6 Figures by Learning Excel-VBA and Other Skills

Step 141 - 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