Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Wait for refresh/calc before proceeding
I have a sheet that uses an MS Query to pull data.
I also have a bunch of vlookups looking at that data. In a vba procedure, I want to Refresh All, then hide some unused rows. But I have to wait until the refresh and calc is finished to know what rows will be unused. How can halt the macro until the refresh and calc is done? So far I just have: Sub RefreshAll() ActiveWorkbook.RefreshAll <hide routine End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
F9 Calc refresh does not work... | Excel Discussion (Misc queries) | |||
My graphs no longer refresh w/new data, why? auto calc is on. | Charts and Charting in Excel | |||
Wait until MSQuery Refresh finished | Excel Programming | |||
Wait for Pivot Refresh to Complete | Excel Programming | |||
Wait for Pivot Refresh before continuing Code Execution | Excel Programming |