JorgeJ

Hello. I'm new to this forum, so If I mess up in posting and have to post a few times please excuse me.

I am using VBA with Excel 97. I am trying to pass an array as a parameter to a subroutine. It doesn't compile. I keep getting an error. It occurs to me that I may be doing something wrong, or maybe VBA with Excel 97 doesn't have the capability to do what I want.

Option Explicit
Dim A() As Double

Sub test2(v() As Double)
v(1) = 17
End Sub




Sub test1()
ReDim A(9) As Double
test2 (A)
End Sub

By the way, is it possible to upload files in this forum?

Thank you.

Csharp

you need to remove the brackets from test2 (A) , it should be test2 A
eg:

JorgeJ

Thank you very much. That works. Do you know if it is possible in VB/Excel97 to have a function return an array. The following declaration doesn't work. What should I be doing?

Option Explicit

Dim A() As Double


Function VectorSum(v1() As Double, v2() As Double) As Double()
'no code yet
End Function

herilane

Works for me... what error are you getting?