ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Comments autofit (https://www.excelbanter.com/excel-programming/285083-comments-autofit.html)

Valeria[_2_]

Comments autofit
 
Dear Experts,
I have a worksheet with different cell comments.
I would like to select them all and adjust their size
automatically.
I am trying to use something like:
For Each cmt In ActiveSheet.Comments
'No idea of what I have to put here!
Next cmt

But any other suggestion on how to do this is welcome!
Many thanks in advance,
kind regards,
Valeria


All times are GMT +1. The time now is 02:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com