Column Widths help ?
 

I have a macro that creates new worksheets from a main table ... is
there a line of code that will automatically :confused: set the width
of columns to the widest value ?

Thanks all ...


--
GazMo
------------------------------------------------------------------------
GazMo's Profile: http://www.excelforum.com/member.php...o&userid=14610
View this thread: http://www.excelforum.com/showthread...hreadid=272396

Column Widths help ?
 

From the macro recorder

Columns("E:E").EntireColumn.AutoFit

--

HTH

RP

"GazMo" wrote in message
...

I have a macro that creates new worksheets from a main table ... is
there a line of code that will automatically :confused: set the width
of columns to the widest value ?

Thanks all ...


--
GazMo
------------------------------------------------------------------------
GazMo's Profile:
http://www.excelforum.com/member.php...o&userid=14610
View this thread: http://www.excelforum.com/showthread...hreadid=272396

Column Widths help ?
 

Have you tried Columns.AutoFit ?
"GazMo" wrote in message
...

I have a macro that creates new worksheets from a main table ... is
there a line of code that will automatically :confused: set the width
of columns to the widest value ?

Thanks all ...


--
GazMo
------------------------------------------------------------------------
GazMo's Profile:
http://www.excelforum.com/member.php...o&userid=14610
View this thread: http://www.excelforum.com/showthread...hreadid=272396