Insert Concatenate formula in Cell
Thank you both!
"Tim Zych" wrote:
ActiveCell.FormulaR1C1 = "=R" & nextrow & "C3&"",""&R" & nextrow & "C4"
Brackets make the Row/Column relative to the formula (not used in the above
example).
=R1C1 will always refer to A1
=R[5]C[2] , if A1 is going to contain the formula, refers to C6.
"Karen53" wrote in message
...
Gary,
Thanks for making a stab at it. It was worth a shot.
"Gary Keramidas" wrote:
someone that uses r1c1 will have to respond, i just took a stab at it. i
use a1
references.
--
Gary
"Karen53" wrote in message
...
Thanks for your reply. I tried it but I get a syntax error.
"Gary Keramidas" wrote:
maybe this:
ActiveCell.FormulaR1C1 = "=R[" & nextrow & "]C3 &" & """,""" & "& R["
&
nextrow
& "]C4"
--
Gary
"Karen53" wrote in message
...
Hi,
I am having trouble inserting a formula to concatenate two cells
into
another cell with a comma separating them.
Here is one of my attempts:
MainPage.Select
With MainPage
Range("BA").Select
ActiveCell.formulaR1C1 = "= R" & NextRow & "C3" & "&" & "," _
& "&" & "R" & NextRow & "C4"
End with
What am I missing?
Thanks
|