ありがとうございます。 Private Sub CommandButton1_Click() Dim a, b, c, d As Single
c = 0 d = 1 For b = 1 To 5 For a = 1 To 5 c = c + 3 Sheets("Sheet1").Cell(a, b).Value = c d = d + 1 Sheets("Sheet1").Cell(a + 10, b + 10).Value = d Next Next End Sub
上記のとおりにやりましたが、それでも、 Sheets("Sheet1").Cell(a, b).Value = c