Thread: ActiveCell.Address to return non Absolute reference
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default ActiveCell.Address to return non Absolute reference
Hi,

maybe

myAddress = ActiveCell.Address(0, 0)

Mike

"PCLIVE @cox.net" wrote:


myAddress = ActiveCell.Address

This will return something like "$A$1".
Is there a way to have this return the non-absolute reference of "A1"
withoug having to use a worksheetfunction such as Substitute?

Thanks in advance.
Paul



Reply With QuoteReply With Quote