Solved: display msgbox in R1C1 style of C12

**ilyaskazi** · 10-07-2005, 06:22 AM

if my active cell is on "C12"

display msgbox of its address in R1C1 style

**mvidas** · 10-07-2005, 06:28 AM

Hello,
You should just be able to use:
[vba]MsgBox ActiveCell.Address(1, 1, xlR1C1)[/vba]Matt

**ilyaskazi** · 10-07-2005, 06:41 AM

thanku, it is solved

**Bob Phillips** · 10-07-2005, 10:16 AM

Originally Posted by mvidas

[vba]MsgBox ActiveCell.Address(1, 1, xlR1C1)[/vba]

small evangelising suggestion on the principle

[VBA]MsgBox ActiveCell.Address(True, True, xlR1C1)[/VBA]

Thread: Solved: display msgbox in R1C1 style of C12