I have a series of sheets that uses a button on sheet 1 to refresh all the
data in the other sheets. I then press another button, again on sheet 1 do
the preset calculations to each sheet using a self written macro. What I want
to know is, is it possible to write a pause into a macro that will last long
enough for all the refreshing to finish before the calculations start? The
refresh usually takes about 90 seconds but this is variable according to
connection speed and time of day, etc...