Quote Originally Posted by Paul_Hossler View Post
If something other than a Range is selected (i.e. a Shape, Chart, etc.), it won't work
Good idea. But sadly, this is not an explanation here. What I posted here was actually just a sample, which I wrote for testing, and with which I could still repro the issue, and of course I selected a range when testing it. The context of the original code, which always worked, did not change. And I experienced it in at least 4 different macros, which all suddenly exhibit this strange behavior. I say “strange” because I don't think VBA should ever conk out just like that.


Quote Originally Posted by SamT View Post
What, in around or about, your computing system recently changed ...
Both Windows (10) and Office (2007) are changing constantly, thanks to MS's automatic updates. Other than that, nothing changed since the last time at least one of the macros ran without a problem (some 4 days ago).