Formatting column width from macro

[macro_user]

hi...
i have a sheet say sheet1... i copy sheet1 through my macro and rename it to sheet2... in sheet2, i need the column width to be big... i dont know how to say this, but the columns width should be formatted in sheet2 from my macro... suppose i have 1 big line of data, i want the column to be resized according to the data present inside the columns... kindly help me on this...

 

[Justin_B]

Hi,
Try inserting --

Cells.Select
    [code]Selection.Columns.AutoFit

After the sheet / data has been copied  to the new sheet

 

[macro_user]

Thank you... will check tat...