Linest in VBA problem

H

headly

Rather than write values or formulas to cells, I'm writing a function that
requires a linest and intercept using variables that store ranges for x and y
inputs. So my code looks like this
varM = WorksheetFunction.LinEst(varYVariable, varXVariable)
where varYVariable is a range like C22:C23 and varxvariable is a range like
D30:E30 (although variables declared with variant data type)
The runtime error is
1004 - Unable to get the LinEst property of the WorksheetFunction class
 
J

Joel

Wneh you assign arYVariable or varXVariable it should be with a set statement

set arYVariable = Range("C22:C23
set varXVariable = Range("D30:E30")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top