and I repeat what I said previously.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Tom Ogilvy" wrote in message
...
What you show would indicate IndexSim is an array

Dim IndexSim(1 to 20) as Double

for cnt = 1 to 20
' code that changes inputs to gBmProcess
IndexSim(cnt) = IndexSim(Cnt) = gBmProcess(Kt, r, q, Vol, TMat - TNow)
if indexSim(cnt) = LowerRange and IndexSim(cnt) <= UpperRange then
msgbox cnt & ". " & IndexSim(cnt) " & is within bounds"
else
msgbox cnt & ". " & indexSim(cnt) & " is out of bounds"
end if
Next

--
Regards,
Tom Ogilvy

"Suz84" wrote:


IndexSim is simply a value to a function, that is what I meant to say:


Code:
--------------------

IndexSim(Cnt) = gBmProcess(Kt, r, q, Vol, TMat - TNow)

--------------------


It produces a value which I would like to know if it is within the
constraint above.


--
Suz84
------------------------------------------------------------------------
Suz84's Profile:
http://www.excelforum.com/member.php...o&userid=36189
View this thread:
http://www.excelforum.com/showthread...hreadid=567415