Sub test1() Dim i&, arr, lastrow&, CON lastrow = [a65536].End(xlUp).Row arr = Range("a3:a" & lastrow) For i = 3 To lastrow [c1] = arr(i - 2, 1) [d1] = [c1] * 5 Range("b" & i) = [d1] CON = MsgBox("继续进行?", vbYesNo + vbQuestion, "温馨提示") If CON = vbNo Then Exit Sub Next End Sub