I have a macro that prints a message to the user, then calculates hundreds of
links (several minutes), then needs to clear the message. The macro is
basically, "print message, calculate, clear message". Will Excel wait until
it finishes updating the links before going to the next step in the macro to
clear the message? I cannot use the "wait" or "OnTime" command because there
is no way to predict how long the calculation will take.
Thanks.