I've stumbled across a very strange problem while performing linea
regression analysis on data with a macro I'm writing.

I've included a link to a sample worksheet I created which illustrate
the problem. Basically, the LINEST function if used as a cell functio
is fine with pretty much any data range thrown at it. However, if yo
attempt to perform a LinEst within VBA, a range of more than 2730 dat
points causes the macro to stop with a type mismatch.

In the worksheet included, all that must be changed are the value i
MinRow and MaxRow. The macro included will attempt to perform a LinEs
calculation and write the parameters to cells along with writing manua
LINEST formulas to cells for Excel to compute. If the range is greate
than 2730 points (i.e. a range of 2-2731 is OK but not 2-2732), th
LINEST values in the cell will update and work fine, but the macro wil
stop and be unable to perform the LinEst calculation in the macro.

I've tested and confirmed this behavior in both Excel 97 and Exce
2000.

If anybody has a clue as to why that happens and (more importantly)
fix for it, I would be most grateful.

http://www.ryanvm.net/linesttest.zi

--
Message posted from http://www.ExcelForum.com