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
Dim LR As Long
LR = Range("A" & .Rows.Count).End(xlUp).Row...