Some relatively easy question:
Suppose I pass a matrix from spreadsheet to VBA as Variant


Code
-------------------

Public Function foo(matrix As Variant)

End Function

-------------------


How do I get the dimensions of the matrix?
(i.e. what is the equivalent of LBound,UBound for this case)

How do I address the elements of this matrix
(i.e. what is the equivalent of matrix(i,j) for this case)

Thanks a lot

--
Message posted from http://www.ExcelForum.com