Hi,
I have an Excel sheets which has a list of services table where certain row has 0 value i want to print those sheets but i want to auto hide those 0 value row and column from that sheet automatically.
Thank you
Printable View
Hi,
I have an Excel sheets which has a list of services table where certain row has 0 value i want to print those sheets but i want to auto hide those 0 value row and column from that sheet automatically.
Thank you
this may work but if you just want to see non blank cells, then you could use this codeCode:Sub AutoFilter()
Range("A1:Z300").AutoFilter
Selection.AutoFilter Field:=10, Criteria1:="<>"
End Sub
Sub Macro3()
Sub TurnFilterOff()
'removes AutoFilter if one exists
Worksheets("Sheet1").AutoFilterMode = False
End Sub
Try this
- Open an Excel workbook
- Select Tools/Macro/Visual Basic Editor
- In the VBE window, select Tools/Project Explorer
- Select the worksheet module for the linked sheet
- Copy and paste the code into this Module
- Now select File/Close and Return To Microsoft Excel
- Save your changes...
Now download this attachment to see the code
HideBlankLinkedRows.zip 8.94KB
you can just use the filers from the menu and do the same thing without this code..