array function in VBA has issues

rameshjeni · May 9th 2012

I tried a simple array sub routine to pass an array from a sheet (a1:a10) and receive this array into another sub routine. The idea is to do an elaborate array multiplication. It doesn't seem to work. Not sure where am I going wrong as this is a standard code taken from MSDN site

Code

Sub Pass_array()
            Dim multiplicant1 As Variant
            multiplicant1 = Range ("a1:a10").Value
            receive_array multiplicant1
         End Sub


         Sub receive_array(thisarray) 'is it here?
            For i = 1 To UBound(multiplicant1)
            	MsgBox multiplicant1(i, 1)
            Next
         End Sub

Display More

any suggestions?

**rory** · May 9th 2012

Re: array function in VBA has issues

the second part should be

Code

Sub receive_array(thisarray) 'is it here?    For i = 1 To UBound(thisarray)
        MsgBox thisarray(i, 1)
    Next i
End Sub

array function in VBA has issues

Participate now!

Share