B Breck Nov 6, 2003 #1 I have a 7 sheet workbook. I would like not to print a worksheet if a specific cell is blank. How can this be accomplished?
I have a 7 sheet workbook. I would like not to print a worksheet if a specific cell is blank. How can this be accomplished?
R Ron de Bruin Nov 6, 2003 #2 Try this macro Breck Sub test() Dim sh As Worksheet For Each sh In ThisWorkbook.Worksheets If sh.Range("a1").Value <> "" Then sh.PrintOut Next End Sub
Try this macro Breck Sub test() Dim sh As Worksheet For Each sh In ThisWorkbook.Worksheets If sh.Range("a1").Value <> "" Then sh.PrintOut Next End Sub
