Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple ranges to Auto Filter
Is there a way to only auto filter some ranges and ignor
others. This is the formula I'm using at the moment, it will autofilter the columns C,D & E but I would also like to add to filter the colum I2:I65536 an not to filter column F,G and H. When I try to add the I range in the formula all of the other ranges will display as AutoFilter (ble). Private Sub Workbook_Open() 'check for filter, turn on if none exists With Worksheets("Time Entry") If Not .AutoFilterMode Then .Range("C2:F65536").AutoFilter End If .EnableAutoFilter = True .Protect password:="", _ Contents:=True, UserInterfaceOnly:=True End With End Sub Thank you for you responce! Kevin |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple ranges to Auto Filter
Debra Dalgleish has some code at:
http://www.contextures.com/xlautofilter03.html#Hide That you can modify. Kevin B wrote: Is there a way to only auto filter some ranges and ignor others. This is the formula I'm using at the moment, it will autofilter the columns C,D & E but I would also like to add to filter the colum I2:I65536 an not to filter column F,G and H. When I try to add the I range in the formula all of the other ranges will display as AutoFilter (ble). Private Sub Workbook_Open() 'check for filter, turn on if none exists With Worksheets("Time Entry") If Not .AutoFilterMode Then .Range("C2:F65536").AutoFilter End If .EnableAutoFilter = True .Protect password:="", _ Contents:=True, UserInterfaceOnly:=True End With End Sub Thank you for you responce! Kevin -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Filter - Multiple Conditions? | Excel Discussion (Misc queries) | |||
Auto filter for multiple columns | Excel Discussion (Misc queries) | |||
auto filter on multiple rows | Excel Worksheet Functions | |||
Auto Filter Multiple Selections | Excel Discussion (Misc queries) | |||
How do I auto-filter multiple ranges on one worksheet? | Excel Worksheet Functions |