I am trying to run the worksheet function Minverse in VBA using:
result = Application.WorksheetFunction.MInverse(pt_array)
This works ok if pt_array is a range taken from a worksheet
(eg pt_array = range("A1:c3"))
However if I try and incorporate an array directly with VBA
(eg pt_array(1)=1 ; pt_array(2)=2 ... etc)
the function fails.
I guess I need to convert my array to a range somehow - and I'd rather
not write it out to a worksheet and then have to read it back in.
Any Ideas ?
---
Message posted from
http://www.ExcelForum.com/