Insert Concatenate formula in Cell
 

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

Insert Concatenate formula in Cell
 

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

Insert Concatenate formula in Cell
 

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

Insert Concatenate formula in Cell
 

What do the brackets do?

Thanks

"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

Insert Concatenate formula in Cell
 

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

Insert Concatenate formula in Cell
 

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

Insert Concatenate formula in Cell
 

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

Insert Concatenate formula in Cell
 

Karen,

I think this does it:

ActiveCell.FormulaR1C1 = "=R" & NextRow & "C3&"",""&R" & NextRow & "C4"

hth,

Doug

"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

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