Thanks for your reply. I tried your suggestion (unlock worksheet first) and as I expected, the result was that all data on the worksheet was deleted - all text and formulas. I can run the code on a system running Office 2013 or 2010, it works just fine.
I'm curious, is it possible to open the document in compatibility mode for those versions in 2016?
|