The following code which worked well in MS Excel 2011 generates the error below in MS Excel 2016 and I'm unable to resolve the issue!
Dim Commnt As Comment
For Each Commnt In Application.ActiveSheet.Comments ' Autosize all comment boxes on the sheet
Commnt.Shape.TextFrame.AutoSize = True
Next
Screenshot 2018-07-18 12.30.51.png
What's changed and how do I accomplish in MS Excel 2016?
I neglected to mention the important aspect that I'm now using MS Excel 2016 on a MacBook Pro running macOS 10.12.6 (High Sierra)
Bookmarks