Button VBA run-time error 2147319767 (80028029)

[paulym666]

Hi,
I have a very simple VBA script that reapplies filters when I click on a button. It has worked for years without any problem. Today, all of a sudden, when I click on it I get this message:

When I click on debug I see this:

I'm using Excel in Office 365.

Any ideas what caused this?

Thanks

 

[frabulator]

I don't think your code itself is at fault, rather there is a formula or cell reference on the page that is messed up, not allowing a recalculation. Double check any new formulas and see if something has changed.