View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Valeria[_2_] Valeria[_2_] is offline
external usenet poster
 
Posts: 24
Default 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