?? Create a Public SUB with an array as parameter. ??
 

I created a class

public sub FindInIt(myArray() as double)
...
€¦
End sub

When Im creating an object to call that sub ,
Obj.FindInIt(ThisismyArray) then

I receive an error message that says €¦. Compile error expected =

like if it was a function. My question is can I pass an array by reference?

Thanks.

?? Create a Public SUB with an array as parameter. ??
 

Read the VBA help on the Call statement.

NickHK

"Barb" wrote in message
...

I created a class

public sub FindInIt(myArray() as double)
..
.
End sub

When I'm creating an object to call that sub ,
Obj.FindInIt(ThisismyArray) then

I receive an error message that says .. Compile error expected =

like if it was a function. My question is can I pass an array by
reference?

Thanks.