Home |
Search |
Today's Posts |
#1
|
|||
|
|||
looping a calculation until workbook closes
OK, cell A1 has a date and time in the future and cell A2 has "=NOW()". Cell
A3 has A1-A2 to get a countdown of sorts. The only problem is that it only calculates when the workbook is first opened or data is altered in the workbook. How do I get it to loop the "Calculate" command continuously while the workbook is open? So it has a countdown that is actually counting down while you're looking at it? I don't plan on doing anything else with the workbook besides use it as a countdown timer. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW DO I SUM TWO CELLS FROM ONE WORKBOOK TO ANOTHER WORKBOOK? | Excel Worksheet Functions | |||
macro to browse for workbook, pick up data and looping | Excel Worksheet Functions | |||
Unprotect Workbook | Excel Discussion (Misc queries) | |||
Workbook Unexpectedly Closes Immediately | Excel Discussion (Misc queries) | |||
Stubborn toolbars in Excel | Excel Discussion (Misc queries) |