View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
-\) -\) is offline
external usenet poster
 
Posts: 18
Default 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