Help with VBA Runtime error 1004

HELP! I am running Excel 2016 on my Macbook pro. A couple things you should know: I am new to 2016 Excel and I don't know much about macros or VBA. One of our forum members wrote an Excel program for my golf league, which is attached.

From what I see, the program does everything I want it to. THE problem is: when I launch the program, I get a runtime error. So I click on DEBUG which takes me to the debug window. What I see there is a vertical line of code that is unreadable because the characters are partially cut off vertically. I suspect there might be a problem with that particular code. The program writer tells me all is fine when operating on his PC, but it just will not work in my macbook.

I hope someone out there can fix this. I feel almost certain this issue points to my Mac. If you have any particular questions, I could hook you up with the Excel genius that wrote this program...

Originally Posted by gmr4evr1

Was the code written run on a PC? If so, that might be the cause of the error, sometimes code written for a pc version wont work on a MAC....not without some tweaking.

.

Yes, it was written on a PC.