Testing if Variant is Range or Double?

  • Thread starter Thread starter Don Wiss
  • Start date Start date
D

Don Wiss

So I rewrote my interpolation function to take in input as a numeric array
that can be either in Option Base 0 or 1. It is a Variant. Is there some
way I can tell if this input is a range instead of numeric? Then I can
convert it to values and make this new function also handle the argument
that the exisiting function takes. And so replace it.

Don <donwiss at panix.com>.
 
Don,

Sub test()
Dim var As Variant

var = CDbl(123.456)
' Set var = Range("A1")
If TypeOf var Is Range Then MsgBox "It's a range" Else MsgBox "It's not
a range"
End Sub

Rob
 
Rob van Gelder said:
Sub test()
Dim var As Variant

var = CDbl(123.456)
' Set var = Range("A1")
If TypeOf var Is Range Then MsgBox "It's a range" Else MsgBox "It's not a range"
End Sub
Click to expand...

Thanks! It worked like a charm in XP. I couldn't find where "TypeOf var Is
Range" comes from. It will also have to work under 97.

Don <donwiss at panix.com>.
 
Look under help for IF

(see the options under condition).

It is supported in Excel 97.
 
Back
Top