| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Writing Array formula through macro
Hi,
I want to create an array formula in a particular cell, through macro. I cannot enter it directly as the cell changes depending on other parameters. If I try to enter the formula through macro, it shows the text-{=SUM(IF(Q9:Q12<'Rejected',I9:I12,0))}, instead of showing the value. Pls help. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel: VB Macro programming problem with formula writing | Excel Programming | |||
| Writing a simple macro or formula | Excel Programming | |||
| Writing a range to an array... | Excel Programming | |||
| VB Macro writing a formula to a cell | Excel Programming | |||
| Prb: Writing Array functions in VBA | Excel Programming | |||
![Shilps[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
