If TypeName(rng) = "Range" Then
MsgBox "Range"
ElseIf TypeName(rng) = "Variant()" Then
If IsArray(rng) Then
MsgBox "Array"
End If
End If


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Smallweed" wrote in message
...
Does anyone know an easy way of telling whether the input argument of a
UDF
is an Excel range, a VBA array or a variant? IsArray doesn't work because
it
returns a True for all cases. Thanks.