Redline
01-24-2011, 09:06 AM
I am using an add-in that has a spline() function to interpolate missing values from a range. It works fine on the computer that runs the reports, but the computer that people use the view the report doesnt have the add-in installed (and that is not an option).
To get around this, I thought I could copy/pastespecial (xlvalues) and save the worksheet so that only the actual values would remain, but each time I do that I get #NAME in the field.
Any thoughts how to show the physical results of the spline() function without leaving the formula?
This does NOT work, and I am left with the cells being literally '#NAME' instead of the results of the spline function;
For i = 2 To 24
Sheets("Hist").Cells(3, i + 2).Formula = "=Spline(Data!$A$2:$A$10,Data!$C$2:$C$10," & Chr(66 + i) & "2,TRUE)"
Next i
Sheets("Hist").Range("D3:Z3").Copy
Sheets("Hist").Range("D3").PasteSpecial xlValues
To get around this, I thought I could copy/pastespecial (xlvalues) and save the worksheet so that only the actual values would remain, but each time I do that I get #NAME in the field.
Any thoughts how to show the physical results of the spline() function without leaving the formula?
This does NOT work, and I am left with the cells being literally '#NAME' instead of the results of the spline function;
For i = 2 To 24
Sheets("Hist").Cells(3, i + 2).Formula = "=Spline(Data!$A$2:$A$10,Data!$C$2:$C$10," & Chr(66 + i) & "2,TRUE)"
Next i
Sheets("Hist").Range("D3:Z3").Copy
Sheets("Hist").Range("D3").PasteSpecial xlValues