NBVC
Well-known Member
- Joined
- Aug 31, 2005
- Messages
- 5,828
Hi,
I have a line of code in a macro that allows the macro to pause for 20 seconds in order for calculations to finish in the spreadsheet before going on to the next step. My code is:
Is there any way of replacing this line with something that pauses for the exact amount of time it takes for the spreadsheet calcs to finish. I don't really like using the fixed amount to time. 20 seconds may be too little or too much depending on the sheet size.
Thanks in Advance.
I have a line of code in a macro that allows the macro to pause for 20 seconds in order for calculations to finish in the spreadsheet before going on to the next step. My code is:
Code:
Application.Wait Now + TimeValue("00:00:20")
Is there any way of replacing this line with something that pauses for the exact amount of time it takes for the spreadsheet calcs to finish. I don't really like using the fixed amount to time. 20 seconds may be too little or too much depending on the sheet size.
Thanks in Advance.