The "Runtime Error 13: Type Mismatch" and "Runtime error -2147483640: Automation Error" you are encountering in Excel 2011 on a Mac can be caused by several issues related to the VBA code in your template. These issues might be due to differences in how VBA is executed on Mac compared to Windows, data type mismatches, or problems with the code itself.
- Check for Data Type Mismatch (Runtime Error 13) - Handle Automation Errors (Runtime error -2147483640) By carefully inspecting your code and handling potential errors gracefully, you should be able to identify the root cause of these runtime errors and resolve them. If the issue persists, you might consider sharing the specific part of the code that causes the error for more detailed assistance.
