Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Running worksheet function in VBA
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/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Running worksheet function in VBA
pt_array must be a matrix not a vector. In other words
yuo have it with one dimension when it should have two pt_array(1,1)=1 pt_array(1,2)= nnn .... pt_array(1,10)= nnnn pt_array(2,1)= nnn pt_array(2,2)= nn .... pt_array(2,10)=nnn .... .... pt_array(10,10)=nnn The advantage of loading the array from a sheet is obvious .... unless you're generating the array as a reslt of some other operation of course. Patrick Molloy Microsoft Excel MVP -----Original Message----- 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/ . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I set up a running balance worksheet ? | Excel Worksheet Functions | |||
New Running Total for each worksheet | Excel Worksheet Functions | |||
How do i get the running balance from one worksheet to another? | Excel Worksheet Functions | |||
Worksheet Running Very Slow | Excel Worksheet Functions | |||
Running Code in an XLA from a Worksheet | Excel Programming |