wait for data to be stable
 

I have a column of data. I want to wait for data to be stable for
about a second before running a function or event macro. Can this be
done?

wait for data to be stable
 

Hi,

I think your going to have to help us by describing what your definition of
un(in)stable data is

however if you want a pause try this

Application.Wait (Now + TimeValue("0:00:05"))

But a note of warning your data could still be showing signs of instability
even after the 5 seconds has elapsed:)

Mike

"Fan924" wrote:

I have a column of data. I want to wait for data to be stable for
about a second before running a function or event macro. Can this be
done?

wait for data to be stable
 

I could have worded that better. Can a worksheet be put on pause while
I input data from a file? Trying to speed up the process. My checksum
routine is trying to add the contents of the column while it is
loading and really slowing things down.

wait for data to be stable
 

Thinking now. I could erase the cell with the checksum routine, input
file data, and put back the checksum routine after the read is
complete. That would be faster. It would be better if I could halt
all page functions during file read.

wait for data to be stable
 

I got an idea from another thread. Can I change calculations mode for
automatic to manual (and back again) in a macro? It really did speed
things up.

wait for data to be stable
 

I found it and it works great!

Application.Calculation = xlCalculationManual

Application.Calculation = xlCalculationAutomatic