Each results in an overflow error in Step mode (obviously the comment needs to be removed). '[Note, I am using an integer for illustration purposes and to show Integer type works. 'However, the macro does not work - where noted - in Step mode on my Apple Mac 'It also works in the standard "Run" mode on Apple machines 'The following works on Windows operating systems Take a closer look at the macros to see if you have used the same shortcut for any other macro records. Basic, but many people forget to check macros.
'Operating system: Mac OS Catalina version 10.15.3 Excel Shortcuts are not working on Mac Excel Shortcuts not working because any macro shortcut is assigned. 'Excel version: Excel for Mac version 16.37 (20051002) 'Option Base 1 'It makes no difference whether this command is in or out I have modified my spreadsheet slightly to incorporate all three comments I have received. I have followed your advice and updated to the latest version of Excel, but to no avail.
The solution usually involves updating Word via Microsoft Update but it depends on the type of problems you are experiencing. Thank you very much for the time you have taken to consider my problem. The frustrating thing for Mac users is that many of these bugs didn’t affect the Preview version of Office 2016 For Mac and only started to emerge once the final version was released.
'However, when running the macro in Run mode (ie not in Step mode) then the macro works I know that starting with Excel for Mac 2016, Excel is sandboxed, meaning you cannot save files wherever you want via VBA code. It only seems to happen on Excel for Mac 20. It does not appear that this error occurs on Excel for Mac 2011. xlsx file because the format or extension is not valid. Each results in an overflow error in Step mode. Run-time error ‘1004’: Method ‘SaveAs’ of object ‘Workbook’ failed. Excel for Mac crashes and slow performance FIXED Excel does not respond when using 'Save as Picture' WORKAROUND Excel prompts you to grant access to files and then hangs or shows a warning that it cannot open the. I am using Excel for Mac version 16.34 with Mac OS Catalina version 10.15.3. Others use a macro that is giving errors, even if they are just in Step mode. The errors do not occur on my brother's Windows PC. If I open an Excel spreadsheet on my Apple Mac and create the macro below then it runs okay in Run mode, but I end up getting an overflow error if I run the macro in Step mode.