| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
adding data to new column
keyser,
ActiveCell.FormulaR1C1 = _ "=IF(RC[" & -res & "]<"""",RC[" & -res & "]&"" comments"","""")" HTH, Bernie MS Excel MVP wrote in message oups.com... I condensed it down to: myRng(33, 2).FormulaR1C1 = "=SUM(R[-31]c:r[-1]c)" Now I would like to add the formula : =IF(<Col1<"",<Col1&" comments","") is an earlier column in the sheet. I tried: myRng(1, Res + 2).FormulaR1C1 = "=IF(C[-Res]<"""",C[-Res]&"" comments"","""") " but this bombs. Can you tell me what the correct format of the formula should be in this macro? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding digits in a column based on data in a separate column | Excel Discussion (Misc queries) | |||
| Adding column data based on match in 2nd column - Help | Excel Worksheet Functions | |||
| Removing one column of data and adding another column | Excel Discussion (Misc queries) | |||
| Adding data to existing data that has a unique number in column | Excel Discussion (Misc queries) | |||
| Adding column data | Excel Worksheet Functions | |||
Threaded Mode
