I finally got this to work, sort of.
For those curious about the code, it calculates least squares
polynomial regression.
To get it to work, I had to do the following
Change B(i) to B(1)
Know that it will continue to do the the do loop. I had to set the end
condition in a subroutine so when it
Thanks for the idea but it doesn't seem to work. I am probably messing
up the subroutine formats. I hate to post long code but here it is.
Any advice would be welcome.
Option Explicit
Dim A(11, 12) As Variant, XX_values(11, 11) As Variant, XY_values(11)
As Variant
Dim X(200) As Variant, Y(200) A
Hi Larry,
Usual cause of that behaviour is other event macros.
Start with: Application.EnableEvents = False
Then your code.
Then at the end: Application.EnableEvents = True
Regards - Dave.
> Date: Wed, 1 Jul 2009 10:22:49 -0700
> Subject: $$Excel-Macros$$ Stop with output subroutine
> From: