Insert Concatenate formula in Cell

[Karen53]

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

 

[Gary Keramidas]

maybe this:

ActiveCell.FormulaR1C1 = "=R[" & nextrow & "]C3 &" & """,""" & "& R[" & nextrow
& "]C4"

 

[Karen53]

Thanks for your reply. I tried it but I get a syntax error.

maybe this:

ActiveCell.FormulaR1C1 = "=R[" & nextrow & "]C3 &" & """,""" & "& R[" & nextrow
& "]C4"


--


Gary

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

 

[Karen53]

What do the brackets do?

Thanks

maybe this:

ActiveCell.FormulaR1C1 = "=R[" & nextrow & "]C3 &" & """,""" & "& R[" & nextrow
& "]C4"


--


Gary

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

 

[Gary Keramidas]

someone that uses r1c1 will have to respond, i just took a stab at it. i use a1
references.

--


Gary

Thanks for your reply. I tried it but I get a syntax error.

maybe this:

ActiveCell.FormulaR1C1 = "=R[" & nextrow & "]C3 &" & """,""" & "& R[" &
nextrow
& "]C4"


--


Gary

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

 

[Karen53]

Gary,

Thanks for making a stab at it. It was worth a shot.

someone that uses r1c1 will have to respond, i just took a stab at it. i use a1
references.

--


Gary

Thanks for your reply. I tried it but I get a syntax error.

maybe this:

ActiveCell.FormulaR1C1 = "=R[" & nextrow & "]C3 &" & """,""" & "& R[" &
nextrow
& "]C4"


--


Gary


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

 

[Tim Zych]

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.

Gary,

Thanks for making a stab at it. It was worth a shot.

someone that uses r1c1 will have to respond, i just took a stab at it. i
use a1
references.

--


Gary

Thanks for your reply. I tried it but I get a syntax error.

:

maybe this:

ActiveCell.FormulaR1C1 = "=R[" & nextrow & "]C3 &" & """,""" & "& R["
&
nextrow
& "]C4"


--


Gary


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

 

[Doug Glancy]

Karen,

I think this does it:

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

hth,

Doug

 

[Karen53]

Thank you both!

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.

Gary,

Thanks for making a stab at it. It was worth a shot.

someone that uses r1c1 will have to respond, i just took a stab at it. i
use a1
references.

--


Gary


Thanks for your reply. I tried it but I get a syntax error.

:

maybe this:

ActiveCell.FormulaR1C1 = "=R[" & nextrow & "]C3 &" & """,""" & "& R["
&
nextrow
& "]C4"


--


Gary


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