Show filtered value from row 5

[patni]

Hey guys ,

I got his code to filter the sheet based on cell value in range "X1:AA2"
Thanks to PCI and Richard for this code,

<code style="margin: 0px; padding: 0px; font-style: inherit; font-weight: inherit; line-height: 12px;">Private Sub Worksheet_Change(ByVal Target As Range)
If (Intersect(Target, Range("X1:AA2")) Is Nothing) Then Exit Sub
Range("A1:Z50000").CurrentRegion.AdvancedFilter Action:=xlFilterInPlace, CriteriaRange:=Range("X1:AA2")
End Sub</code>
the problem is that when I type in the range "X1:AA2" , then it hides these ranges as well because it filters and displays the data from row 2 onwards.


Is there any way to display the filered results from row 5 onwards?

This will ensure that my range for filerting stays right at the top.

I am not able to attach any file

This post is cross posted. Here is the link to it.
https://www.excelforum.com/excel-pr...ed-filter-modifying-formulae.html#post4941553

I would be grateful if anyone could help me