Running LinEst() from VBA
 

I am trying to run the linest() function from a VBA procedure, but keep
getting the
"Unable to set the FormulaArray property of the Range class" error message.
I am using the following VBA code within the procedure.
' select range for primary cubic values
ActiveSheet.Range("E25:H29").Select

' run linest() function
Selection.FormulaArray = _
"=LINEST(.Range(Y_rngStr)& "", "" & .Range(X_rngStr)& ""^{1,2,3},,TRUE)"""
Any suggestions?

Running LinEst() from VBA
 

I have answered this often in the past. Here is a link to those answers:

http://tinyurl.com/yrmeeq


--
Regards,
Tom Ogilvy


"Mitch" wrote:

I am trying to run the linest() function from a VBA procedure, but keep
getting the
"Unable to set the FormulaArray property of the Range class" error message.
I am using the following VBA code within the procedure.
' select range for primary cubic values
ActiveSheet.Range("E25:H29").Select

' run linest() function
Selection.FormulaArray = _
"=LINEST(.Range(Y_rngStr)& "", "" & .Range(X_rngStr)& ""^{1,2,3},,TRUE)"""
Any suggestions?