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?

R1C1 Formula
 

Double up the double quotes:

.formular1c1 = "=RC[7]&"" (""&RC[8]&"")""

Paul W Smith wrote:

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?

--

Dave Peterson

R1C1 Formula
 

For quotes within quotes, use two quotes

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Paul W Smith" wrote in message
...
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?