ExcelBanter - Comments autofit

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Comments autofit (https://www.excelbanter.com/excel-programming/284767-re-comments-autofit.html)

Jim Rech

Comments autofit

Perhaps...

Sub aa()
Dim Cmt As Comment
For Each Cmt In Sheet1.Comments
Cmt.Shape.Width = 200
Next
End Sub

--
Jim Rech
Excel MVP

All times are GMT +1. The time now is 02:47 PM.