Need help passing an array as an argument
Only a variant can hold an array. If you dim somearray as a string array,
then I wouldn't think you could assign another array to it.
--
Regards,
Tom Ogilvy
"blc" wrote in message
...
Hello all,
I wanted to ask for some quick help. For the life of me I cannot figure
out why the following code will not work... Any hints/comments?
'''''''''''''''''''''''''''''''''''''''''''''''''' '''''''''''''''''''
'In a class module written in VB6 I have the following paired property
procedure
Public Property Get SomeArray( ) As String( )
SomeArray = mstrHiddenArray
End Property
Public Property Let SomeArray(ByRef TempArray( ) As String)
mstrHiddenArray = TempArray
End Property
'''''''''''''''''''''''''''''''''''''''''''''''''' '''''''''''''''''''
'Inside an Excel VBA module I call the above property procedu
Call MyObject.SomeArray(gstrGlobalArray)
'Note: gstrGlobalArray is a TWO-dimensional string array...
'''''''''''''''''''''''''''''''''''''''''''''''''' '''''''''''''''''''
In the Excel VBA module where I invoke the property procedure I get an
"Invalid Use of Property" error message... What do you think? Forget
programming & get another career??? lol
Anyways, anything anybody could contribute would be helpful...
Thanks,
blc
|