| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro writing formulas
Hi, so I'm having some issues writing a line in a macro that I'm
working on. I'm not sure why the below formula doesn't work: ActiveCell.FormulaR1C1 = "=bds(RC[-8]&"" equity"",$i $1,""cols=7;rows=10"")" which should get copied into the Excel sheet like this: =BDS(A2&" equity",$I$1,"cols=7;rows=2") Can anyone help me out here? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| writing formulas | New Users to Excel | |||
| writing if formulas | Excel Worksheet Functions | |||
| Writing formulas ... | Excel Programming | |||
| Writing Formulas | Excel Worksheet Functions | |||
| Writing Array Formulas in VBA | Excel Programming | |||
Threaded Mode
