Thread: R1C1 and the $ sign
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Adrian T[_4_] Adrian T[_4_] is offline
external usenet poster
  
Posts: 17
Default R1C1 and the $ sign
Hello:

If I do this..
ActiveWorkbook.Worksheets("Sale").Range("E11").For mula = "=R1C1"

I get..
=$A$1 in my E11

Is there a way to get rid the dollar signs? What I want is =A1.

Thanks!
Adrian T
Reply With QuoteReply With Quote