PDA

View Full Version : 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:
MsgBox ActiveCell.Address(1, 1, xlR1C1)Matt

ilyaskazi
10-07-2005, 06:41 AM
thanku, it is solved

mvidas
10-07-2005, 06:50 AM
Glad to help!

Bob Phillips
10-07-2005, 10:16 AM
MsgBox ActiveCell.Address(1, 1, xlR1C1)

small evangelising suggestion on the principle

MsgBox ActiveCell.Address(True, True, xlR1C1)