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