sheet / page address and set column width Free Excel Macros (VBA) | Excel Programs

Copy Macro

'For online Excel courses click: https://www.excelsizeyeter.com/excelwithkenan.com/udemy_giris.php 
 
Sub Summary_All_Worksheets_With_Formulas()
    Dim Sh As Worksheet
    Dim Newsh As Worksheet
    Dim myCell As Range
    Dim ColNum As Integer
    Dim RwNum As Long
    Dim Basebook As Workbook
 
    With Application
        .Calculation = xlCalculationManual
        .ScreenUpdating = False
    End With
 
    Set Basebook = ThisWorkbook
    Set Newsh = Basebook.Worksheets.Add
 
    On Error Resume Next
    Newsh.Name = "Summary-Sheet"
    If Err.Number > 0 Then
        MsgBox "The Summary sheet already exist in this workbook."
        With Application
            .DisplayAlerts = False
            Newsh.Delete
            .DisplayAlerts = True
            .Calculation = xlCalculationAutomatic
            .ScreenUpdating = True
        End With
        Exit Sub
    End If
 
    RwNum = 1
    'The links to the first sheet will start in row 2
 
    For Each Sh In Basebook.Worksheets
        If Sh.Name  Newsh.Name And Sh.Visible Then
            ColNum = 1
            RwNum = RwNum + 1
 
            Newsh.Cells(RwNum, 1).Value = Sh.Name
            'Copy the sheet name in the A column
 
            For Each myCell In Sh.Range("A1,D5:E5,Z10")    '   -

No	Macro Name
1	sheet / page address and set column width
2	list formulas on new sheet / page
3	specifies in detail how many formulas are in the book (on new sheet / page)
4	finds formulas on active sheet / page lists new sheet / page
5	excel operators hk
6	inserts months as sheet / pages Specifies days in detail
7	summer adds months to sheet / pages
8	specifies in detail how many references the book contains (on new sheet / page)
9	Adds sheet / pages based on data in column A and writes data up to column D
10	printing and prompting
11	column finds full cells and encapsulates print area
12	opening a web sheet / page
13	watermark printing (faded font on sheet / page background)
14	comparison; sheet / page1 sheet / page2 abc columns
15	active cell printing
16	Finds filled cells in column a and encapsulates print area
17	Open a new worksheet with a name entered in textbox1
18	add sheet / pages as menus
19	sheet / pages with toolbars and menus
20	assigns date to the next line when data is entered in certain cells on the sheet / page

Excel Free Macros (VBA)

Sheet / Page Address And Set Column Width

Online Excel Courses

Services

How can we help you?

Subscribe to our Youtube Channel?

Keywords