Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Auto hide rows and column in Excel 2007

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 28-02-2009
Member
 
Join Date: Dec 2008
Posts: 120
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

Reply With Quote
  #2  
Old 28-02-2009
Member
 
Join Date: May 2008
Posts: 4,562
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
this may work but if you just want to see non blank cells, then you could use this code
Reply With Quote
  #3  
Old 28-02-2009
Member
 
Join Date: May 2008
Posts: 4,829
Re: Auto hide rows and column in Excel 2007

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
Reply With Quote
  #4  
Old 28-02-2009
raptor1234
 
Posts: n/a
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..
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Auto hide rows and column in Excel 2007"
Thread Thread Starter Forum Replies Last Post
How to auto insert rows in excel Yakov Windows Software 7 19-04-2012 05:55 PM
Is it possible to have rows above 65,000 in Excel 2007 Nyota MS Office Support 2 21-02-2012 05:07 PM
Is it possible to set auto-refesh for column which has a auto filter in Excel RopeME MS Office Support 2 17-02-2012 07:05 PM
Help me transposing multiple rows into one column with row labeling in Excel RYAN$ MS Office Support 2 17-01-2012 05:31 PM
VBA to hide the rows in Microsoft Excel Lanka Boy MS Office Support 1 14-01-2012 02:12 PM


All times are GMT +5.5. The time now is 10:28 PM.