Search results for query: *

You got it Tony, thanks! This is exactly what i was looking for. I appreciate your help, Logratio

...my last I get the solution if I transfer one column of data from the multidimensional array to a single array myArrayA and use, for instance, the funtion: Application.Max(myArrayA) How can I use 'directly' in the function one column of data from the multidim array?

bad news :) INDEX(ArrayName;0;2) seems to work on sheet but not with an array at run-time. I am still stuck... Logratio

My issue is to pass to a function (like Min) all values in one of the columns of a multidimensional array created at run-time. I Think I have found the solution. What I need is to use INDEX: INDEX(ArrayName;0;2) This way I get all elements stored in column 2 of the array and use them to...

My point is that I cannot (want not) call, for instance, code such as: array1 = ActiveSheet.Range("A1:D25").Value Application.Min(array1) I need to bypass the sheet and send the data from the array directly to the function Logratio

I mean a multidimensional array, one with more than one column of data. Thanks for the attempt, I need computing several stats and am looking for a way to pass data from the array to the function, avoiding the sheet. The Min case is an easy one ;) Logratio

Hi, Can I compute at run-time (without writing the data on sheet) a function like the one below where “rngDataFit” is a MultiArray or a variable containing data from a MultiArray? Application.Min(Range(rngDataFit)) For instance, the MultiArray(r1006, c10) contains the data. I’d...

I have an Excel add-in that from Workbook_Open sets a reference to Solver and Workbook_Close removes the reference. The weird thing is that the code shown below can't set the reference without preventing the small password form to pop up (the one that appears when trying to access a protected...