以下程式碼
請問
我哪裡寫錯?
1.請幫我修正
2.請幫我寫個更容易執行的版本讓小弟對照學習
Private Sub CommandButton1_Click()
Worksheets("1").cell(2, 2).Value = Worksheets("3").cell(3, 5)
Worksheets("1").cell(3, 2).Value = Worksheets("3").cell(3, 6)
Worksheets("1").cell(4, 2).Value = Worksheets("3").cell(3, 7)
Worksheets("1").cell(5, 2).Value = Worksheets("3").cell(3, 8)
End Sub |