VBA Excel commands that work in Windows and Mac

I have an excel file with a macro that runs on VBA script. The macro works great on windows office 16, but will not work on a Mac office 16. There must be problems in the commands I am using that are not compatible in a Mac.

Could any of you read through my code below and see if you can recommend which commands/functions are causing the problem? And recommend a replacement that will perform the same across OS platforms (windows/mac)? Thanks!


Object:

Please Login or Register  to view this content.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here