1. VBA.Filter函数
Filter(sourcesrray, match[, include[, compare]])
2. VBA.Filter例子
Option Explicit
Sub arr_filter()
Dim arrRegion As Variant
Dim arr1() As String, arr2() As String
arrRegion = Array("東京都", "神奈川県", "千葉県", "茨城県", "大阪府")
arr1 = VBA.Filter(arrRegion, "県", True)
arr2 = VBA.Filter(arrRegion, "県", False)
Debug.Print "arr1 : " & Join(arr1, ",")
Debug.Print "arr2 : " & Join(arr2, ",")
End Sub