Multiple ranges to Auto Filter


K

Kevin B

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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top