Autofit Comments

[Anant]

Hi,
I have a sheet which has many comments and I want to autofit all th
comments (Just like we do in columns) at the press of a button. is tha
possible through vba?
Thanks in advanc

 

[sujata_ghosh]

hi,

try this one on
onclick event of the button, write

for example:

Columns("D").EntireColumn.AutoFit

if you autofit some specify the row and column then the value t
specific columns and row and use it. other wise you just change you
desier column and use it.

sujata

 

[David McRitchie]

Hi Anant,
Cell Comments ( see resizing )
http://www.mvps.org/dmcritchie/excel/ccomment.htm#resizing