Hi,
I have a problem with the linest function. I'm trying to get the Qudratic regression of a set of values and display it in a sheet. However I keep getting the error "Unable to get the linEst property of the WorksheetFunction Class". My code is:
When I use the excel formula "=LINEST($B2:$B43,$A2:$A43^{1,2})" this works fine. I just can't figure out how to do the exact same thing using the LinEst function in VBA.Please Login or Register to view this content.
Bookmarks