Variant and Array

[spencer.sadkin]

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

 

[Bob Phillips]

Maybe try

msgbox var(1, 1)

--
HTH

Bob

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

 

[Gary''s Student]

You need to discover what var really is. First exanime IsArray(var) and then
look at the Ubound and Lbound values.

 

[spencer.sadkin]

Maybe try

msgbox var(1, 1)

--
HTH

Bob

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











- Show quoted text -

msgbox var(1,1) worked thanks