Look under help for IF

(see the options under condition).

It is supported in Excel 97.

--
Regards,
Tom Ogilvy

Don Wiss wrote in message
...
Rob van Gelder wrote:

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

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.