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

's Computer Specifications

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.

's Computer Specifications

Read the VBA help on the Call statement.

NickHK

"Barb" <(E-Mail Removed)> wrote in message
news:272F5E0E-5D55-4DD7-A789-(E-Mail Removed)...
>
> 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.
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
array as out parameter	Hendri Adriaens	Microsoft C# .NET	5	15th May 2007 08:01 PM
Parameter Query & Public Variables?	=?Utf-8?B?RS5RLg==?=	Microsoft Access Getting Started	1	9th Apr 2007 11:58 AM
public array	Circe	Microsoft Excel Programming	6	17th May 2005 11:45 PM
ReDim Object array as parameter of Variant array	Peter T	Microsoft Excel Programming	4	10th May 2005 02:11 PM
Array as parameter from VC++ DLL to VB.NET	Sarvjeet Saini	Microsoft ASP .NET	0	28th Aug 2003 09:07 AM