R1C1 Formula

  • Thread starter Thread starter Paul W Smith
  • Start date Start date
P

Paul W Smith

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?
 
Double up the double quotes:

.formular1c1 = "=RC[7]&"" (""&RC[8]&"")""
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?
Click to expand...
 
Back
Top