VBAで、いくつかの項目を配列に入れたいとき、まずDimで配列を宣言して、次にmyList(0) = ..., myList(1) = ...と、一行ずつ値を代入していく…。この方法、少し手間がかかると感じませんか？ あらかじめ中身が決まっている、比較的小さな配列を、もっとシンプル ...

普段のVBA業務でこんな風なプログラムを組んだことはありませんか？？ Sub CommandButton1_Click() 'ボタンクリック時 Dim i As long With Worksheets("Sheet1") For i＝1 to 100 If .cells(i,1) = "OK" then’もしセル内がOKの場合 .cells(i,2) = "OKです" else .cells(i ...

ArrayTools is a Project that allows easy data manipulation when working with Arrays and Collections in VBA (regardless of host Application). Operations like sorting, filtering, converting, reversing, ...

To check if a value exists in an array, we can loop through its elements. However there is another solution! You can use the INDEX () function, native to Excel and in ...