View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default IsArray on Variant/Object/Range returns true??

I wouldn't think so.

--
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