Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can i write a vba code to get string or integer "C15" from $c$15?
I use Excel VBA function.
I have CELL address : $c$15 How can i write a vba code to get string C15? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can i write a vba code to get string or integer "C15" from $c$15?
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. -- Cordially, Chip Pearson Microsoft MVP - Excel www.cpearson.com "d" wrote in message ... I use Excel VBA function. I have CELL address : $c$15 How can i write a vba code to get string C15? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can i write a vba code to get string or integer "C15" from $c$15?
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. -- Regards, Tom Ogilvy "d" wrote in message ... I use Excel VBA function. I have CELL address : $c$15 How can i write a vba code to get string C15? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to write formula for countif (range,"<2" &"3") | Excel Discussion (Misc queries) | |||
How do I write an excel formula with a text answer ("yes" or "no") | Excel Discussion (Misc queries) | |||
Converting "uppercase" string data to "lower case" in CSV file | Excel Discussion (Misc queries) | |||
text string: "91E10" in csv file auto converts to: "9.10E+11" | Excel Discussion (Misc queries) | |||
is it possitle i write"1"and "one" will show in next coloumn. | Excel Discussion (Misc queries) |