Dim allmydataArr As Variant allmydataArr = Range("a1").CurrentRegion.Value’表データ全部をallmydataArrに入れる Range("g1:l2000").Clear
Dim starttime As Single, stoptime As Single starttime = Timer’ストップウォッチで時間計測開始
Dim piceddataArr(1 To 5900, 1 To 6) As Variant ’検索結果格納用 Dim sagadata As Long: sagadata = 2 ’2とする場合 Dim hitdata As Long: hitdata = 0 Dim i As Long, j As Long
For i = LBound(allmydataArr, 1) To UBound(allmydataArr, 1) ’最小から最大まで
If allmydataArr(i, 2) = 11 And allmydataArr(i, 6) = sagadata Then hitdata = hitdata + 1 For j = 1 To 6 piceddataArr(hitdata, j) = allmydataArr(i, j)’検索結果1つづつ格納する Next j End If Next i
If hitdata >= 1 Then Range("g1:l" & hitdata) = piceddataArr’検索結果格納データをセルに出力 Else MsgBox "No data" End End If