I have a spreadsheet that totals 12 columns left to right. What I want to do is NOT print the records that have a total of 0. This code works if the total column is blank. However, I have a formula in the total column to give me the totals. So it isn't null or blank and it shows on the print command.
Any ideas?
Thanks.
If ActiveSheet.Name = "TOTALS" Then
Cancel = True
Application.EnableEvents = False
Application.ScreenUpdating = False
With ActiveSheet
On Error Resume Next
.Columns("N").SpecialCells(xlCellTypeBlanks).EntireRow.Hidden = True
.PrintOut
.Columns("N").SpecialCells(xlCellTypeBlanks).EntireRow.Hidden = False
End With
Application.EnableEvents = True
Application.ScreenUpdating = True
End If
Microsoft Office