|
Dim regex As Object, i As Integer<br/>Application.ScreenUpdating = False<br/>Application.EnableEvents = False<br/>Set regex = CreateObject("VBScript.Regexp")<br/>regex.Pattern = "[0-9]"<br/>regex.ignorecase = True<br/>regex.Global = True<br/>For i = 2 To [a65536].End(xlUp).Row<br/>牋?regex.Pattern = "[0-9]"<br/>牋?Cells(i, "e").Value = regex.Replace(Cells(i, 1).Value, "")<br/>牋?regex.Pattern = "[a-z]"<br/>牋?Cells(i, "f").Value = regex.Replace(Cells(i, 2).Value, "")<br/>Next<br/>Set regex = Nothing<br/>Application.ScreenUpdating = True<br/>Application.EnableEvents = True |
|