how to do something different based on return type

[brulet]

I have a function declared as a Variant, and sometimes it will return a range, and sometimes a single value. is there a way to setup an if statement depending on the return type?

<code>
If TypeName(findNearest(referenceFlow, referenceDTQFlow, 0) = "Double") Then
interpolate = 9999.9999
Exit Function
Endif
</code>

I hate using exits, but under certain circumstances, I want the program to not do anything. Thanks.

BT

 

[brulet]

It's returning a typemismatch, which I don't understand at all..

<code>
Function interpolate(referenceFlow As Double, referenceDTQFlow As Range, modelDTQPercentage As Range) As Double
Dim percentage As Double
Dim nearestFlows, nearestPercentage As Range
MsgBox TypeName(findNearest(referenceFlow, referenceDTQFlow, 0))
If TypeName(findNearest(referenceFlow, referenceDTQFlow, 0) = "Double") Then
interpolate = findNearest(referenceFlow, referenceDTQFlow, 0)
Exit Function
</code>

The msgbox returns "Double", but it stalls on the if statement! Any ideas why?

 

[brulet]

ahah stupid me. Bracket in the wrong place.. Can this thread be erased LOL..