Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sequential Sub Procedures
I have a Sub procedure which pulls data into multiple Excel 97 worksheets
from an Access database via MS Query. The data is refreshed with the command "ActiveWorkbook.RefreshAll". I then have another Sub procedure to change row height on all the worksheets to fit the newly imported data. My problem is that the row height Sub runs before the RefreshAll command has finished and so none of the rows are changed to match the new data. Could anyone suggest how I can make the row height procedure run only when the RefreshAll command has completed. TIA Roger |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Separating sub procedures | Excel Discussion (Misc queries) | |||
Non-sequential VLOOKUP function -OR- sequential sort of web query | Excel Worksheet Functions | |||
Sequential names on Sequential pages | Excel Worksheet Functions | |||
VBA -- procedures as arguments? | Excel Programming | |||
Splitting Procedures | Excel Programming |