Thread: HOW TO: Get cell address from a range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Juan Pablo González Juan Pablo González is offline
external usenet poster
  
Posts: 226
Default HOW TO: Get cell address from a range
Set the first two parameters of .Address to False:

rgeMyCell.Address(False, False)

--
Regards

Juan Pablo González

"Kevin McCartney" wrote in message
...
HI TWIMC,

If I set a range to the cell B1 I'd like to be able to a get the cell
address in the style of B1 not B$1$, so what code do I need to use instead
of:

rgeMyCell.Address


TIA
KM


Reply With QuoteReply With Quote