九色国产,午夜在线视频,新黄色网址,九九色综合,天天做夜夜做久久做狠狠,天天躁夜夜躁狠狠躁2021a,久久不卡一区二区三区

Sub CollectData()
    Dim Sht As Worksheet, Rng As Range, k&, n&
    Application.ScreenUpdating = False
    '取消屏幕更新，加快代碼運行速度
    n = Val(InputBox('請輸入標題的行數(shù)', '提醒', 1))
    If n < 0 Then MsgBox '標題行數(shù)不能為負數(shù)。', 64, '提示': Exit Sub
    '取得用戶輸入的標題行數(shù)，如果為負數(shù)，退出程序
    Cells.ClearContents
    '清空當前表數(shù)據(jù)
    For Each Sht In Worksheets
    '遍歷工作表
        If Sht.Name <> ActiveSheet.Name Then
        '如果工作表名稱不等于當前表名則進行匯總動作……
            Set Rng = Sht.UsedRange
            '定義rng為表格已用區(qū)域
            k = k + 1
            '累計K值
            If k = 1 Then
            '如果是首個表格，則K為1，把標題行一起復制到匯總表
                Rng.Copy
                [b1].PasteSpecial Paste:=xlPasteValues
                [a1] = '工作表名稱'
                [a1].Offset(n).Resize(Rng.Rows.Count - n, 1) = Sht.Name
            Else
                '否則，扣除標題行后再復制粘貼到總表，只粘貼數(shù)值
                Rng.Offset(n).Copy
                With Cells(ActiveSheet.UsedRange.Rows.Count + 1, 1)
                    .Resize(Rng.Rows.Count - n, 1) = Sht.Name
                    .Offset(0, 1).PasteSpecial Paste:=xlPasteValues
                End With
            End If
        End If
    Next
    [a1].Activate
    Application.ScreenUpdating = True '恢復屏幕刷新
    MsgBox '匯總OK'
End Sub