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)
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.