Clinton has a workbook containing over 200 worksheets that get populated by various people in his company during the month. At the end of the month he needs to print these worksheets. Not all the worksheets contain data and Clinton only wants to print the worksheets that contain data so he doesn’t waste paper. He wonders if there is, perhaps, a macro that he can use to print only those worksheets that have a value in cell G41.
The answer is that such a macro could be written rather easily. It would only need to figure out how many worksheets there are, check cell G41 on each of them, and then print only if there is something in that cell. The following macro performs just these operations.
Sub PrintMost() Dim wks As Worksheet For Each wks In ActiveWorkbook.Worksheets If Not IsEmpty(wks.Range("G41")) Then wks.PrintOut End If Next Set wks = Nothing End Sub
The macro could be easily modified to perform other operations, such as asking if any given worksheet should be printed or asking how many copies should be printed.