如何在Excel VBA 中使用正则表达式

Sub test() Dim arr() As String Dim oRegExp As Object Dim oMatches As Object Dim iNum As Integer '定义正则对象' Set oRegExp = CreateObject("vbscript.regexp") Dim iRow As Integer iRow = Sheets(1).UsedRange.Rows.Count For