Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Isolate array formulas in a range
I am trying to add functionality to an add-in by creating my own. Basically
I am going to: 1. Accept a user-entered range 2. Evaluate the formulas to determine if they came from the particular add-in 3. Use some text evaluation/manipulation to find a position within the formula and add an argument. 4. Enter this new formula. The twist is that often times these formulas are array formulas. If the user selects a range that contains multiple array formulas, or a mix of array and non-array formulas, I need to be able to isolate each one. Any ideas on how I accomplish this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert Array Formulas to Regular Formulas | Excel Worksheet Functions | |||
Isolate UNIQUE combination of Z cells from a range N that adds up | Excel Worksheet Functions | |||
Formulas assignment from array to range in VSTO Excel doesn't work | Excel Worksheet Functions | |||
Array Formula Not Working with Range with Formulas | Excel Discussion (Misc queries) | |||
How to activate array formulas in a range of cells all at the same time? | Excel Programming |