Setting Comment size on a cell

  • Thread starter Thread starter Clark Kent
  • Start date Start date
C

Clark Kent

Can you dynamically set a comment size based on the amount of text it holds?
I see a way to set the size using comment.shape.height, etc. but is there
some sort of "autofit" similar to range.columns.autofit() ?

Thanks.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to insert pictures in comments 8
cell comments, hiding columns, "Cannot shift objects off sheet" 1
Code to add comments to selected cells within a selected range 30
If ActiveCell has a comment then exit sub 22
Working with Cell Comments - VBA 14
Excel Default Text Size in Comments box 1
Comment Box Size = 125% Fill Picture Size 1
How to make rows autofit when cells merge and multi line text inside 1

Back
Top