Trouble switching to the M1 Mac or Excel in Office16.54

[jvbeaupre]

That's encouraging.
I'll try that

I did try that, but the same problem occurs.
The problem seems deeper and related to 32-bit vs 64-bit implementations of VBA7.
(https://docs.microsoft.com/en-us/off...tions-overview)
I read the above reference think it's related, but I really don't know how to proceed.

I'd be very interested in hearing from Mac M1 users of Excel VBA.

Thanks,
Jim