Alan Nicoll
Board Regular
- Joined
- Feb 3, 2004
- Messages
- 71
Annoying little problem. I want to pass an array to a function and have the function return the array, modified. But this fails:
I get an error message that I can't assign an array this way.
I can create a Variant variable to receive the result, i.e., this works:
But if I want to continue calling my data "TestArray" I have to assign it to NewArray, element by element.
Do I just have to bite the bullet and make TestArray Public?
Seeking guidance. ray:
Code:
TestArray = Condense(TestArray)
I can create a Variant variable to receive the result, i.e., this works:
Code:
Dim TestArray(10,10) as String
Dim NewArray as Variant
NewArray = Condense(TestArray)
Do I just have to bite the bullet and make TestArray Public?
Seeking guidance. ray: