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
|