Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Array problem: Key words-Variant Array, single-element, type mismatch error | Excel Programming | |||
Array problem: Key words-Variant Array, single-element, type mismatch error | Excel Programming | |||
ReDim Object array as parameter of Variant array | Excel Programming | |||
Variant Array | Excel Programming | |||
variant array containing cel adresses convert to actual ranges-array | Excel Programming |