Dim bott, i, j, m, n, b As IntegerDim s1, s2, ss1, ss2, ss As Strings1 = "sheet1"s2 = "sheet2"bott = Sheet1.Range("b65536").End(xlUp).RowIf bott < 28 Then
MsgBox "B列数据不充分"
GoTo ex1End IfFor i = 1 To 19
s1 = "sheet" & i
s2 = "sheet" & (i + 1)
For j = i + 7 To bott - 1
ss = ""
|