G
Guest
Guest
When I copy a worksheet and then paste it to another, some formatting doesn't follow. ex. column width etc. What code do I use to make the column width paste too. Used this code to copy.
Worksheets("template").UsedRange.SpecialCells(xlCellTypeVisible).Copy
Worksheets(2).Activate
Range("A1").Select
ActiveSheet.Paste
Worksheets("template").UsedRange.SpecialCells(xlCellTypeVisible).Copy
Worksheets(2).Activate
Range("A1").Select
ActiveSheet.Paste