Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I am stumped. I have a large VBA program with about 8 subroutines and maybe 50-70 variables. The program itself is too complicated to explain, however as a gross approximation, it works about like this: Private Sub Main_Clicl() for x = 1 to 1000 if x^2+10x+25 = 100 then exit sub next cells(1,1)=x End Sub So, the program would search for an answer. Anyway, let's just say that for this example, when I click on a button on the screen, I get an answer in cells(1,1). So, I click it one time and I get the correct answer; I click a second time and I get an incorrect answer. I click again, and I get the right answer. And this pattern continues. I am not using any static variables. All my variables are global. Can someone please explain what might be happening. thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Strange behavior with old macro now throws error with "Application | Excel Programming | |||
Sum Time - strange result (site & cpearson researched) | Excel Worksheet Functions | |||
Excel 2007 (Beta) - strange behavior of macro | Excel Programming | |||
Strange Personal Macro Workbook Behavior | Excel Discussion (Misc queries) | |||
Strange macro behavior! | Excel Programming |