for example:

? isarray(thisworkbook.Sheets)
False
? isarray(Activesheet.Shapes)
False
? isarray(Range("A1"))
False
? isarray(Range("A1:A10"))
True

I can't think of another object that returns an array for the value (or
default) attribute. That doesn't mean there are not any, but I can't think
of one.

--
Regards,
Tom Ogilvy




"QuantDev" wrote in message
om...
"Tom Ogilvy" wrote in message
...
Check for a range first

if typename(varr) is "Range" then
' it's a range
elseif isarray(varr) then
' it's an array

--

Thanks Tom.

As far as you know, am I going to get "true" for isarray for others
variant/object/* combinations?
thx