Auto hide rows and column in Excel 2007

[Murena]

Sponsored Links

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

[Glenny]

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

this may work but if you just want to see non blank cells, then you could use this code

[Macarenas]

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..