Hi Scott
not quite sure what you're trying to do. Could you give a more specific
example (or the code you already have)?

--
Regards
Frank Kabel
Frankfurt, Germany


Scott P wrote:
How do I add a value to an array (in VBA) based upon the output of an
if...then statement? I have two arrays -- if a certain value falls
within a range in array 1, I want to add the corresponding value in
array 2 to a third array, which I will use to hold values for later
calculation.

Thanks in advance for your help.