| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
cell formula in string variable doesnt work
I have: Y1 = "=IF($D24=0,"",$D24-$I$4*TAN(RADIANS(L10)/2))" Y2 = "=IF($D24=0,"",$D24-$I$4*2*TAN(RADIANS(L10)/2))" then try and use: Range("J10").Select ActiveCell.FormulaR1C1 = Y1 Range("J11").Select ActiveCell.FormulaR1C1 = Y2 Why doesnt this work? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| array formula doesnt work from row 32737 | Excel Programming | |||
| Formula doesnt work when copy in different cell | Excel Discussion (Misc queries) | |||
| This Hyperlink formula doesnt work | Excel Programming | |||
| Formula doesnt work | Excel Worksheet Functions | |||
| excel lookup help... already have formula but doesnt always work | Excel Programming | |||
Threaded Mode
