| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
use of variable in array formula
The following array formula is working correctly, but instead of a100 (end
limit) I have to use variable which value is changing time to time . How to rewrite the command to do this task? Range("b2").FormulaArray = "=MIN(if(a2:a1000,a2:a100))" |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Variable Formula - both normal and array | Excel Programming | |||
| Dim an Array with a variable | Excel Programming | |||
| use a variable array in a formula | Excel Discussion (Misc queries) | |||
| Tricky array formula issue - Using array formula on one cell, then autofilling down a range | Excel Programming | |||
| Problem trying to us a range variable as an array variable | Excel Programming | |||
Threaded Mode
