I'm moving many Excel .xlsm files from Windows to an M2 MacBook Pro running Excel for Mac (Microsoft 365) and am wondering: 1) how much of my VB code will break, and 2) if the code might execute differently, but silently, i.e. generating incorrect results without flagging the incompatibility. I found one minor discrepancy: spaces around the exponentiation operator (https://answers.microsoft.com/en-us/msoffice/forum/all/exponentiation-in-excel-vba-for-mac/9ce857cd-...).
Has anyone compiled a list of differences between Windows and macOS Excel VBA? Any suggestions, from macro to micro? Many thanks in advance!
