「Excel VBA」配列の要素の値を変更するサンプル
使用例
Sub testFunc()
Dim cft As Variant
cft = Array("A001", "B002", "C003", "D004")
cft(2) = "test002"
Debug.Print cft(0)
Debug.Print cft(1)
Debug.Print cft(2)
End Sub
Sub testFunc()
Dim cft As Variant
cft = Array("A001", "B002", "C003", "D004")
cft(2) = "test002"
Debug.Print cft(0)
Debug.Print cft(1)
Debug.Print cft(2)
End Sub
Sub testFunc() Dim cft As Variant cft = Array("A001", "B002", "C003", "D004") cft(2) = "test002" Debug.Print cft(0) Debug.Print cft(1) Debug.Print cft(2) End Sub