Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Running macro operations in serial fashion
Is it possible to create a macro that performs an operation, waits
for calculations to end and then moves onto the next operation in the macro in serial fashion ? I'm trying to automate a "calculate and export to text file" process that takes hours to finish. The goal is to run a single macro that allows me to walk away from the entire process instead of waiting for each set of calculations to end and manually starting the next operation. For example, a worksheet has 1,000 cells where each contains a formula. Additionally, the worksheet contains a macro that performs the following: 1) Changes an argument in the formula in each of the 1,000 cells, i.e., =SUM(A1,1) where the value in A1 is changed 2) Waits for calculations to end 3) Exports the worksheet to a text file 4) Changes the same argument again (A1) to another value 5) Waits for calculations to end 6) Exports the worksheet to a text file - Ronald K. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Identify text nums in scrambled fashion | Excel Discussion (Misc queries) | |||
changing math operations for math operations with = sign | Excel Programming | |||
Long running operations | Excel Programming | |||
killing empty spaces in unusall fashion .. | New Users to Excel |