View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Clark Kent[_2_] Clark Kent[_2_] is offline
external usenet poster
 
Posts: 6
Default Setting Comment size on a cell

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.