You say "print the message" and you say "clear the message". Do you have a
message that is being sent to the printer or do you have a message box pop
up on the screen? If you have a message box (using the MsgBox command) pop
up on the screen, all code execution will stop until you click the OK button
in that message box. IOW, the code to "calculate" will not run until the
message box has been manually cleared. Does this help? Otto
"Carl Bowman" wrote in message
...
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.