View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
[email protected] Spencer.Sadkin@gmail.com is offline
external usenet poster
 
Posts: 42
Default Variant and Array

On May 21, 12:43*pm, "Bob Phillips" wrote:
Maybe try

msgbox var(1, 1)

--
HTH

Bob

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

wrote in message

...



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- Hide quoted text -


- Show quoted text -


msgbox var(1,1) worked thanks