Rangeは書き込みが出来ます。
サンプルソース
Private Sub start()
Range(“A1”).Value = “a1”
End Sub
Private Sub start()
Range(“A1”).Value = “a1”
End Sub
:でつなぐことにより複数のセルに書き込めます。
サンプルソース
Private Sub start()
Range(“A1:C3”).Value = “A1:C3”
End Sub
Private Sub start()
Range(“A1:C3”).Value = “A1:C3”
End Sub
実行結果
A1:C3 A1:C3 A1:C3
A1:C3 A1:C3 A1:C3
A1:C3 A1:C3 A1:C3
A1:C3 A1:C3 A1:C3
A1:C3 A1:C3 A1:C3
A1:C3 A1:C3 A1:C3
当然同じ値になります。