I have a macro which replaces the file name in a formula. Sometimes the new
file name does not yet exist and the "Update Value.." box pops up. I hit
CANCEL and the macro continues. Is there a line of code which will cause the
macro to hit cancel and continue without any input from me. I came across
the following code but don't know what to put after THEN
If IsError(ActiveCell.Value) Then

Thanks