Variant and Array
You need to discover what var really is. First exanime IsArray(var) and then
look at the Ubound and Lbound values.
--
Gary''s Student - gsnu2007L
" wrote:
I have a class with variable called pSW
I pass a range ("A1:A5") as variant and set the property.
I then use var= classname.sw and set var which is dimmed as variant
with no problems
if i then say worksheets(1).range("B1:B5")=var the values display
properly.
however if say say msgbox var(1) i get a subscript out of range
error.
any ideas on why this might be? thanks
|