Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula R1C1 | Excel Programming | |||
R1C1 formula question | Excel Worksheet Functions | |||
Addition string from input box in to a formula (eg;R1C1 Formula) | Excel Programming | |||
R1C1 Formula in Excel | Excel Worksheet Functions | |||
Variable in an R1C1 formula | Excel Programming |