|
| |||||||||
| Tags: 2007, auto, column, excel, hide, rows |
![]() |
| | Thread Tools | Search this Thread |
|
#1
| ||||
| ||||
| Auto hide rows and column in Excel 2007
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 |
|
#2
| ||||
| ||||
| Re: Auto hide rows and column in Excel 2007 Code: 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 |
|
#3
| ||||
| ||||
| Re: Auto hide rows and column in Excel 2007
Try this
Now download this attachment to see the code HideBlankLinkedRows.zip 8.94KB |
|
#4
| |||
| |||
| Re: Auto hide rows and column in Excel 2007
you can just use the filers from the menu and do the same thing without this code.. |
![]() |
|
| Thread Tools | Search this Thread |
| |
Similar Threads for: "Auto hide rows and column in Excel 2007" | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Help me transposing multiple rows into one column with row labeling in Excel | RYAN$ | MS Office Support | 2 | 3 Weeks Ago 06:31 PM |
| VBA to hide the rows in Microsoft Excel | Lanka Boy | MS Office Support | 1 | 4 Weeks Ago 03:12 PM |
| How to auto insert rows in excel | Yakov | Windows Software | 6 | 30-12-2011 01:21 AM |
| How do i automatically number rows in Excel 2007 | Atilla | Windows Software | 3 | 21-04-2009 10:48 AM |
| Hide rows in EXCEL | Marc H. | Microsoft Project | 3 | 03-12-2008 02:20 AM |