I had to make changes for this to work -- the copy & paste didn't r

I had to make changes for this to work -- the copy & paste didn't run it successfully right away.
I had to change the back quote (`) to an apostrophe ('). The 1st line in each code is supposed to be a comment, not a running code.
For some reason, typing the code out ultimately caused it to run successfully, despite no change in code. I'd suggest giving that a try for those that are getting stuck. (I was getting the same "Run-time error 9 Subscript out of range" error others were getting)
My only issue is it doesn't clear filters

Hello Ik,

 The run-time 9 error is a result of copying and pasting the code. More specifically, it's the inverted commas/quotation marks (i.e. " ") that are causing the issue. Please edit the code and change (`) to an apostrophe.

Give it a try and let us know if you need help.