Column Width

I have excel sheet with lots of data...
Have data from Column 10 thru 136.
What i need is a macro to set the column width as follows:

Column 10,11,12,14,15,16,18,19,20...and so on ...set width to 12
Column 13,17,21....and so on ... set width to 2...

Help is always greatly appreciated....

Riz Momin

Thank U this would work...

One quick question...how would u set column width series of individual column eg Column Q,U,Y, and so on...

Thank U

Riz Momin

Please Login or Register  to view this content.

Thank u..this will work...


Riz Momin