Sub tx() Dim i, MaxRow As Integer MaxRow = 0 For i = 1 To Sheets.Count MaxRow = WorksheetFunction.Max(Sheets(i).[a65535].End(xlUp).Row, MaxRow) Next i MsgBox MaxRow End Sub
Sub tx() Dim i, MaxRow As Integer MaxRow = 0 For i = 1 To Sheets.Count MaxRow = WorksheetFunction.Max(Sheets(i).[a65535].End(xlUp).Row, MaxRow) Next i MsgBox MaxRow End Sub
Sub aa() '只能求A列最大行号 ROWMAX = 0 Dim i, s As Long s = Sheets.Count For i = 1 To s If Sheets(i).[a65536].End(xlUp).Row > ROWMAX Then ROWMAX = Sheets(i).[a65536].End(xlUp).Row Next i End Sub