將原程式碼:Sub 亂數重置3()
Application.ScreenUpdating = False
[Sheet2!C11:G12].Copy
With Sheets("5隊10場").Range("C8:G27")
.PasteSpecial xlPasteFormulas
.Value = .Value
.Item(1).Select
End With
Application.CutCopyMode = xlCut
If Application.CountIf([J8:J27], "*=*") > 0 Then Call 亂數重置3
Beep
End Sub
另外複製在其下方貼上,
Sub 亂數重置數據3() 改 Sub 亂數重置數據4()
Sheets("5隊10場").Range("C8:G27")
只要改〔工作表名稱〕及〔Range範圍〕即可!