remove filter but keep rows hidden

[snowman1976]

Hello
I just have a general question - is there any coding that will allow me to remove an autofilter at the end of a macro, but leave the rows hidden based on the filter criteria given? I am hoping to be able to do this so the user can unhide certain rows if needed without having to play with a filter?

any help or thoughts would be appreciated

thanks

 

[baitmaster]

don't see any reason why not. Try something like the following (untested):

dim visibleSection as range
 
with range("AutofilterRange")
    set visibleSection = .SpecialCells(xlCellTypeVisible)
    activesheet.showalldata
    .entirerow.hidden = true
end with
 
visibleSection.entirerow.hidden = false

 

[snowman1976]

Thats great, I will give it a shot, thanks