Delaying until Recalcu code is done.
I have a problem.
I write to cell, and I want to wait until ALL code that fires off that event
to finish before I run my code to read the resulting cells.
I tried a DoEvents and that worked in most 99.9% of the cases and has for
years. BUT with the last save the timing got messed up and I had to put in
a 3-5 second delay in this one sheet (looping until timer OldTimer + 5)
Any better way of doing this?
(This was my single step problem, not working it 1 of 2 methods of full
speed operation and when I single stepped it.)
PS.
Excel 2000
|