Macros stopped working after Mac Excel software update

[jeffcp66]

I've been building a spreadsheet for 6 months with several macros, and since I upgraded 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, Procedure declaration errors, object variable errors. I went back to version of my sheet from weeks ago, before recent updates, and they exhibited the same issues. Mostly seems to get tripped up on range variable that have been working fine for months.

I finally determined that it must be the recent Office software update.

Anyone else having this issue with Mac excel?

[alansidman]

Administrative Note:

Welcome to the forum.

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/for-other...l-16-27-a.html