Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
(This is a cross-post)
Hello; I'm trying to correctly pass the range B11:C14 to the Function MyRoots() and return the results by the array function to cells I11:J13. Notice the use of ReDim. Declaring Dim a(m+1,2) As Double in Function MyRoots() would produce a compile error: "Constant expresion required", and also I couldn't declare "a" as a 2D dynamic array! I suspect the array variables declaration in the following example is the problem. The array Function MyRoots() incorrectly returns 0.0 results to cells I11:J13. cell B8::3 cell B9: myTrue cells B11:C14 numerical values cells I11:J13:: array function {=MyRoots(B11:C14, B8, B9)} Function MyRoots (a, m As Integer, polish As String) ReDim a(m + 1, 2) As Double ReDim roots(m, 2) As Double Dim j As Integer, its As Integer Dim x(2) As Double ReDim ad(m + 1, 2) As Double .......................................my code............ For j = 1 To m + 1 ad(j, 1) = a(j, 1) ad(j, 2) = a(j, 2) Next j .......................................my code............ Call Laguer (ad, j, x, its) .......................................my code............ roots(j, 1) = x(1) roots(j, 2) = x(2) .......................................my code............ MyRoots = roots End Function Sub Laguer (a, m, x, its) Dim x1(2) As Double .......................................my code............ x(1) = x1(1) x(2) = x1(2) .......................................my code............ Exit Sub End Sub Your expert help would be greatly appreciated. Regards. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Array Declaration. | Excel Discussion (Misc queries) | |||
Declaration problem | Excel Programming | |||
VBA Declaration problem | Excel Programming | |||
Array Declaration | Excel Programming | |||
dYNAMIC Array declaration, a small correction in my last thread! | Excel Programming |