RECrerar
09-14-2007, 03:51 AM
This a a confusing problem.
I have a variable
Public IERROR3 as integer
If I run the macro under certain conditions this will be set to IERROR3 = 1
My problem is that sometimes if I run the macro and this condition is reached, if I then re-run the macro the variable does not reset to IERROR3 = 0. The very first line of the macro is IERROR3 = 0!!!!!
This produces an error, if I then just click [End] rather than [Debug] on the Debugging form and run the macro again, the error rests itself and the program runs fine.
Any Ideas why this is happening, or how I can prevent it from happening?
I have a variable
Public IERROR3 as integer
If I run the macro under certain conditions this will be set to IERROR3 = 1
My problem is that sometimes if I run the macro and this condition is reached, if I then re-run the macro the variable does not reset to IERROR3 = 0. The very first line of the macro is IERROR3 = 0!!!!!
This produces an error, if I then just click [End] rather than [Debug] on the Debugging form and run the macro again, the error rests itself and the program runs fine.
Any Ideas why this is happening, or how I can prevent it from happening?