Advanced Filter Unique Records and Hidden Rows

[Kigol]

I have code that filters for unique records in place. This works great
but when I try to paste new values into the location which was
filtered, it causes the code to hang. I have determined this is due to
the fact that advanced filter hides rows in it's filtering process.
That being said, is there any way to unhide all of the rows after I am
done working with that list?

 

[Dave Peterson]

Record a macro when you do
Data|Filter|Show All

And you'll have the code you need.