I have the following code for an advanced filter
when running the code , I get a compile error "Else without if ' run time error
It would be appreciated if someone could kindly amend my code
Sub Advanced_Filter()
Dim LR As Long
With Sheets(4)
LR = Range("A" & .Rows.Count).End(xlUp).Row...