You are showing code that suggests that IndexSim is an array, whereas you
call it a function. They are very different (although a function could
return an array), so how about showing the indexSim code.

--
HTH

Bob Phillips

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

"Suz84" wrote in
message ...

Hey All,

Just a quick question. I have a function called -IndexSim- and would
like to set an IF statement so that it is inbetween two values,
-UpperRange- and -LowerRange-. I have used the following:



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

If IndexSim(Cnt) = LowerRange And IndexSim(Cnt) <= UpperRange Then

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

Is this correct, as I don't think it produces the outcome I want?

Please advise,

Many thanks,

Suz84


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