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