| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can you update an array formula using VBA?
I have an excel application with two workbooks. I have written a VBA macro
in workbook 1 that includes a .open command to open workbook 2. Workbook 2 successfully opens, however, none of the array formulas residing in workbook 2 are updated (they all seem to default to a zero value). I have tried changing the screenupdating and calculation properties. Any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array formula: how to join 2 ranges together to form one array? | Excel Worksheet Functions | |||
| Find specific value in array of array formula | Excel Worksheet Functions | |||
| Array functions that I wan to update only on command | Excel Worksheet Functions | |||
| can an array update only once? | Excel Worksheet Functions | |||
| Update Master records -- Array question? | Excel Programming | |||
Threaded Mode
