| 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 |
| 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 | |||
Threaded Mode
