For P = 1 To Arr - 2
If P Mod 100 = 0 Then '满百 , 写到单元格
K = K + 1
Cells(K, 6) = MS1 & " -"
MS1 = ""
MS = """" & Cells(i, 1) & """" & ","
MS1 = MS1 & MS
Else
MS = """" & Cells(i, 1) & """" & ","
MS1 = MS1 & MS
End If
i = i + 1
Next
If MS1 <> "" Then Cells(K, 6) = MS1 ' 末行 不满百 , 写到单元格
End Sub