Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I have a spreadsheet with 51 tabs. Tab_1 is a summary of data contained on the remaining 50 sheets (such as averages and sums). A macro iterates through values of 1 - 100. During each iteration a variable with dependents changes on each of the 50 sheets and resulting data for each iteration is output on the summary tab (output such as the averages and sums for each iteration). The macro works great when I step through it, the problems occur when I run it at full speed. The output data at each iteration does not keep up with the macro, thus the outputs are inaccurate. It's like the macro runs faster than all the calculations are performed and output. Any suggestions to help alleviate this challenge would be greatly appreciated. Thanks!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I write a macro for keeping time? | Excel Programming | |||
Keeping a Macro in a new book | Excel Worksheet Functions | |||
Keeping a Macro in a New Book | Excel Programming | |||
Keeping an Array Filled and running macro from other workbooks? | Excel Programming | |||
Keeping name of worksheet who called macro | Excel Programming |