Hello,
with Excel 2007 you can frame in the region and click:
Format
Autofit column width

Hth

Gabor Sebo





"S S" wrote in message ...
Hello

i would like to find the largest column width in a range e.g. "A1:A20" and
then set all the columns of this range to this largest width. how can i do
that?

Thanx.


Submitted via EggHeadCafe - Software Developer Portal of Choice
Crypto Obfuscator for .NET - Product Review
http://www.eggheadcafe.com/tutorials...or-for-ne.aspx