LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 64
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Msgbox and variants - a deadly combination Peter[_61_] Excel Programming 1 January 24th 07 02:35 PM
mismatch error and Variants T_o_n_y Excel Programming 6 April 25th 06 02:53 PM
can I set row/column label as variants? lily Excel Programming 3 April 4th 06 08:54 PM
Variants vs ranges [email protected] Excel Programming 2 December 6th 05 06:45 PM
Array Parameters as Variants Only TheVisionThing Excel Programming 5 March 25th 05 09:52 PM


All times are GMT +1. The time now is 09:07 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"