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

--
Anan

Excel/VBA Enthusias
-----------------------------------------------------------------------
Anant's Profile: http://www.excelforum.com/member.php...fo&userid=1564
View this thread: http://www.excelforum.com/showthread.php?threadid=27796

hi,

try this one on
onclick event of the button, write

for example:

Columns("D: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

--
sujata_ghos
-----------------------------------------------------------------------
sujata_ghosh's Profile: http://www.excelforum.com/member.php...fo&userid=1643
View this thread: http://www.excelforum.com/showthread.php?threadid=27796

Hi Anant,
Cell Comments ( see resizing )
http://www.mvps.org/dmcritchie/excel...t.htm#resizing
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Anant" wrote ...
I have a sheet which has many comments and I want to autofit all the
comments (Just like we do in columns) at the press of a button. is that
possible through vba?