Hi, I use autofilter in my code as below to add/remove filters..
Is there a way to modify this, for example if my selection is already unfiltered on below range to just skip it? The problem becomes when my range is already unfiltered and I run the below it just adds the filter for me. I want the below only to unfilter the below range
Any suggestions? Thanks so much
LastRow = Cells.Find("*", [A1], , , xlByRows, xlPrevious).Row
Range("B16:AD" & LastRow).Select
Range(Selection, Selection.End(xlToRight)).Select
Range(Selection, Selection.End(xlDown)).Select
Selection.AutoFilter
Bookmarks