| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simplifying code using array
Is there a way to say that MyArray(5) cannot equal any element of the
array, without listing each element, as below? Do MyArray(5) = Int(10 * Rnd) Loop Until MyArray(5) < MyArray(4) And _ MyArray(5) < MyArray(3) And _ MyArray(5) < MyArray(2) And _ MyArray(5) < MyArray(1) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need help simplifying VBA code | Excel Discussion (Misc queries) | |||
| Code needs simplifying | Excel Worksheet Functions | |||
| Simplifying VBA code | Excel Worksheet Functions | |||
| Simplifying array formula which evaluates as error. | Excel Worksheet Functions | |||
| Code to determine if a cell contains an array function? | Excel Discussion (Misc queries) | |||
Threaded Mode
