View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
QuantDev QuantDev is offline
external usenet poster
 
Posts: 5
Default IsArray on Variant/Object/Range returns true??

"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