Thread: R1C1 Formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul W Smith Paul W Smith is offline
external usenet poster
 
Posts: 74
Default R1C1 Formula

I am trying to write a line of code which enters a formula in R1C1
reference, my line of code is:

Range("S1").offset(n,0).formulaR1C1 = "????????"

The problem I am having is getting the text at the end to work to replace
the question marks.

In Excel the formula is =RC[7]&" ("&RC[8]&")", but because of the "s this
does not compile. Can anyone tell me what I use in my formula to achieve
what I want?