Excel Runtime Error 429 in VBA on MAC

I am getting the Runtime error 429 in Excel VBA for my macro. It works fine on a Windows PC. I think it has to do with me using

Please Login or Register  to view this content.

. I am no familiar with writing VBA code for Macbooks. I would like to have help if anyone would not mind in fixing this code to work in Excel on a Mac.

Please Login or Register  to view this content.

Untested

Please Login or Register  to view this content.

However, I think autofilter will do the same and faster...