Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
wait for data to be stable
I found it and it works great!
Application.Calculation = xlCalculationManual Application.Calculation = xlCalculationAutomatic |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sendkeys(keys,wait) how do I use wait | Excel Discussion (Misc queries) | |||
text wrap is not stable | Excel Discussion (Misc queries) | |||
Stable formula | New Users to Excel | |||
Stable chart | Charts and Charting in Excel | |||
Wait for user to change data after msgbox ???? | Excel Discussion (Misc queries) |