D d Aug 29, 2003 #1 I use Excel VBA function. I have CELL address : $c$15 How can i write a vba code to get string C15?
C Chip Pearson Aug 29, 2003 #2 I'm not sure exactly what you want, but the Address property will return the address of a cell or range. E.g., Msgbox Range("$C$15").Address(False,False) See help on Address for more details.
I'm not sure exactly what you want, but the Address property will return the address of a cell or range. E.g., Msgbox Range("$C$15").Address(False,False) See help on Address for more details.
T Tom Ogilvy Aug 29, 2003 #3 sStr = "$C$15" msgbox range(sStr).Address(external:=True) & vbnewline & range(sStr).Value or maybe you want the address sStr = Range("C15").Address(0,0) or to get the value stored in the cell Dim vVal as Variant vVal = Range("C15").Value hopefully you can get what you want from the above examples.
sStr = "$C$15" msgbox range(sStr).Address(external:=True) & vbnewline & range(sStr).Value or maybe you want the address sStr = Range("C15").Address(0,0) or to get the value stored in the cell Dim vVal as Variant vVal = Range("C15").Value hopefully you can get what you want from the above examples.
