AutoFiltering

[peterg999]

Looking for help please... if a value changes in one worksheet, I want the filter (in another worksheet) to update automatically, but I keep getting ""Compile Error: Invalid or Unqualified Reference". My code is attached below.

Can anyone please help.. what am I doing wrong?
Peter

------------------------

Private Sub Worksheet_Change(ByVal Target As Range)

'Look for any changes to worksheet "Sizing Tool", specifically cell I60
If Target.Address = "I60" Then

'If there are any changes, apply these to worksheet "PV"
Worksheets("PV").Range("$A$16:$BO$100").AutoFilter Field:=6, Criteria1:=Worksheets("Sizing Tool").Range("I60").Value
.AutoFilter.ApplyFilter

End If

End Sub

------------------------

 

[initialize]

Why do you need the last line '.AutoFilter.ApplyFilter'?
Your code worked for me if I take away that line and change the if statement to 'if Target.Address = "$I$60" Then'

 

[peterg999]

Thanks, that's great, it worked

 

[initialize]

Hey no problem at all, very glad I could help =).

btw just a heads up you private msg is full for some reason I tried to reply but it wont let me