$$Excel-Macros$$ Re: Stop with output subroutine

2009-07-08 Thread larry
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

$$Excel-Macros$$ Re: Stop with output subroutine

2009-07-02 Thread larry
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

$$Excel-Macros$$ Re: Stop with output subroutine

2009-07-01 Thread Dave Bonallack
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: