Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Function - array with 2 variants
HI all,
I want to write a function that takes an array with 2 optional values (e.g op1 and op2) and returns an array with each value less than op2 replaced by the op2 value, and each value higher than the op1 replaced by the op1 value. Can anyone help? Thanks in advance. ss |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Msgbox and variants - a deadly combination | Excel Programming | |||
mismatch error and Variants | Excel Programming | |||
can I set row/column label as variants? | Excel Programming | |||
Variants vs ranges | Excel Programming | |||
Array Parameters as Variants Only | Excel Programming |