Surpress a Run-Time Error in Excel with a Dialog Box

Originally Posted by Norie

So there's no criteria/logic that can be used in the code to determine whether or not there are sheets to print.

PS The code you posted loops through all the worksheets already.

The criteria for this particular sheet is that if there is a value in cell A607 then it will print, if there is no value in A607 then it will not print.