I'm using Macs, and I've been creating a spreadsheet for seven months with many macros. After I updated two different Macs from Excel 16-26 to 16-27 (standard Office Update), most of my macros will not run. I get range mismatch errors, object variable errors, Procedure declaration errors. I checked saved copies of my document from weeks ago, and they had the same problems, even though they had been working swimmingly for weeks. It usually is stopped on range variables that, again, had been operating correctly for months.

Has VBA on Mac Excel caused anyone else problems? Any ideas on how to fix this?

Thanks!