Width & Merge Cells

https://authentification.site/files/23630062/Test.xls

this is the link dude

without do anything first you run the macro & you will know that what i want

Again do the "for each ... in Sheets" routine. See the comment about skipping the sheet.

Dim Sheet As Variant
    
    For Each Sheet In Sheets
    
        ' if the sheet that you are processing is the one that you dont want to
        ' process then skip it
        If Sheet.Name = "Sheet2" Then GoTo Next_Sheet
        
        Sheet.Select
        
        Columns("A:A").ColumnWidth = 6.14
        Columns("B:B").ColumnWidth = 8.43
        Columns("C:C").ColumnWidth = 8.43
        Columns("D:D").ColumnWidth = 8.43
        Columns("E:E").ColumnWidth = 8.43
        Columns("F:F").ColumnWidth = 8.43
        Columns("G:G").ColumnWidth = 10
        Columns("H:H").ColumnWidth = 10.29
        Columns("I:I").ColumnWidth = 11.57
        Columns("J:J").ColumnWidth = 3.71
        
        Range("A1:J1").Select
        With Selection
            .HorizontalAlignment = xlCenter
            .VerticalAlignment = xlBottom
            .WrapText = False
            .Orientation = 0
            .AddIndent = False
            .IndentLevel = 0
            .ShrinkToFit = False
            .ReadingOrder = xlContext
            .MergeCells = False
        End With
        
        Selection.Merge
        With Selection.Font
            .Bold = True
            .Name = "Arial"
            .Size = 17
            .Strikethrough = False
            .Superscript = False
            .Subscript = False
            .OutlineFont = False
            .Shadow = False
            .Underline = xlUnderlineStyleNone
            .ColorIndex = xlAutomatic
        End With
        
Next_Sheet:
    Next

I Dont Get It Dude

Can You Do It To My Sended File ? & Send Me

I am presuming that you were talking about macro10 and that you wanted to replicate the formatting instruction in that macro for all sheets that are in your workbook (except for some that you would identify, as i have done in the code (sheet2))

https://authentification.site/files/23632090/Test.xls

Jani Jab Run Karte Hain To Yeh Sheets To Bana Daita Hai Aur Data Copy Bhi Kar daita Hai But

Main Chahta Hoon K As It Is Copy Ho Baki Sheets Main. Means Jaab Run Kiye Bagair Sheet1 Main Jo Hai Na Wohi As It Is With Same Margins Aur Jo Jo Cell Merge Hain Wo Merge Bhi Macro Run Karne Pay Baki Sheets Main Jaye......

Hope You Got It Clear Now