array function in VBA has issues

  • 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

    any suggestions?

  • Re: array function in VBA has issues

    the second part should be

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

    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!