Without an example document that fails, it is difficult to determine why you get the error, but if you add an error trap before the 'For Each' line i.e.the error should be suppressed. An example document, would help determine a more robust error trap.On Error Resume Next