P
Peter
Hi -
I am attempting to write to the worksheet, but I get a run-
time error sometimes when I try to access the Application
object. This function call works some times, but not other
times. After some testing, it seems that Excel locks the
Application object when it's under duress (receiving a
tonne of updates from a xll, and user tabbing like mad
between worksheets). When this lock happens, the run-time
occurs.
Can I use a DoEvents or a timer to have this function run
at a different time? Or is there a better solution?
Using Office XP btw! Thanks for your help
I am attempting to write to the worksheet, but I get a run-
time error sometimes when I try to access the Application
object. This function call works some times, but not other
times. After some testing, it seems that Excel locks the
Application object when it's under duress (receiving a
tonne of updates from a xll, and user tabbing like mad
between worksheets). When this lock happens, the run-time
occurs.
Can I use a DoEvents or a timer to have this function run
at a different time? Or is there a better solution?
Using Office XP btw! Thanks for your help