Thread: How can i write a vba code to get string or integer "C15" from $c$15?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default 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?



Reply With QuoteReply With Quote