Black Panther
New Member
- Joined
- Jul 18, 2018
- Messages
- 1
I'm now using MS Excel 2016 on a MacBook Pro running macOS 10.12.6 (High Sierra) and 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
What's changed and how do I accomplish in MS Excel 2016?
Dim Commnt As Comment
For Each Commnt In Application.ActiveSheet.Comments ' Autosize all comment boxes on the sheet
Commnt.Shape.TextFrame.AutoSize = True
Next
What's changed and how do I accomplish in MS Excel 2016?