R1C1 Formula

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?
 
D

Dave Peterson

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula in macro with variable sheet names 4
Problem with line of code / syntax 4
Compile error for formula 1
Why are the two codes below not getting the right formula for myworksheet event change formula? 2
UserForm R1C1 problem 4
Select and Delete 4
Code with formula interfering in worksheet change event 2
Macro to search range for a portion of a specific value and if findit - then paste formula in anothe 1

Top