LinIntrpAsc2D = "Number of rows or columns for given range does not match." The rest of the code is listed for those interested.įunction LinIntrpAsc2D(KnownX As Range, KnownY As Range, KnownZ As Range, X2 As Double, Y2 As Double) As Variantĭim Y0 As Double, Y1 As Double, X0 As Double, X1 As Double, i As Long, j As Long, Z() As Variant, Z1 As Double, Z2 As Double, Xfound As Boolean, Yfound As Boolean Please note that it is enough to use the first 3 lines and part I from the code to get the error. I believe my problem has to do with "knownZ" and how I reference it later in the code. ![]() The error I get is: "Compiler error: Invalid Qualifier" with the Function line highlighted in yellow. ![]() ![]() I am trying to develop a 2D interpolation function.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |