D
decc
I have an excel purchase order form automated using macros. I have a
module named "Setup" in which I define all of my public variables (29
to be exact). In it is an "Auto_Open" sub in which I assign initial
values to the variables. When the users finish filling in the form and
try to print or save it I run a "Check_Entries" sub which checks to
insure specific cells contain data. With some regularity a user will
receive the "Object variable or With block variable not set" error. It
occurs on the first line of code of the "Check_Entries" sub that
contains a variable reference. Further investigation indicates that
defined variables have been lost. This happens about once in every 50
executions of the .xls. It occurs on different machines, different
users and both XP SP2 and Win98SE OS's. I have not been able to
intentionally duplicate the error. Can anyone give me any ideas as to
what might be going on?
BrianG
module named "Setup" in which I define all of my public variables (29
to be exact). In it is an "Auto_Open" sub in which I assign initial
values to the variables. When the users finish filling in the form and
try to print or save it I run a "Check_Entries" sub which checks to
insure specific cells contain data. With some regularity a user will
receive the "Object variable or With block variable not set" error. It
occurs on the first line of code of the "Check_Entries" sub that
contains a variable reference. Further investigation indicates that
defined variables have been lost. This happens about once in every 50
executions of the .xls. It occurs on different machines, different
users and both XP SP2 and Win98SE OS's. I have not been able to
intentionally duplicate the error. Can anyone give me any ideas as to
what might be going on?
BrianG