| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Concatenate and use cell value in formula | Excel Discussion (Misc queries) | |||
| Concatenate text cell and formula cell result | Excel Worksheet Functions | |||
| How do I insert a hard return in a =CONCATENATE formula in excel | Excel Worksheet Functions | |||
| how do i concatenate a string and cell formula and use a comma? | Excel Worksheet Functions | |||
| Insert Concatenate Formula | Excel Programming | |||
Linear Mode
