| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Function syntax
glad it worked - for completeness
xlWs.Range("c1").End(xlDown).Offset(1, 0).Select xlApp.FormulaR1C1 = "=XIRR(R2C:R[-1]C,R2C1:R[-1]C1,0.1)" should have been xlWs.Range("c1").End(xlDown).Offset(1, 0).Select xlApp.Selection.FormulaR1C1 = "=XIRR(R2C:R[-1]C,R2C1:R[-1]C1,0.1)" -- Regards, Tom Ogilvy Forrest wrote in message ... Works lilke a champ. Thanks for the education. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Indirect function syntax | Excel Discussion (Misc queries) | |||
| Syntax for IF function | New Users to Excel | |||
| Syntax for 2 AND conditions within an OR function. | Excel Worksheet Functions | |||
| all function formulas syntax | Excel Discussion (Misc queries) | |||
| NetWorkDays Function Syntax | Excel Worksheet Functions | |||
Hybrid Mode
