On Oct 8, 9:44*pm, "joeu2004" wrote:
PS2.... *I wrote:
"joeu2004" wrote in message

...

REM wrote:
Ideally I would like the numbers to be variables also.

knownY = Array(5,10)
knownX = Array(10,20)
x = 15
y = WorksheetFunction.Forecast(x,knownY,knownX)

Or:

y = WorksheetFunction.Forecast(x,Array(y1,y2),Array(x1 ,x2))
MsgBox y

If you still cannot figure it, provide the relevant VBA context -- *
declaration of variables and code fragment showing how those variables are
set up.

These options work for me.
Many thanks to all.
Rod