|
参与一下
- Sub ExtractData()
- On Error Resume Next
- Dim ws As Worksheet
- Dim arr(), arrtemp(), arrStr() As String
- Set ws = ThisWorkbook.Sheets("签证单格式化")
- arr = ws.Range("A1").CurrentRegion
- For i = 1 To UBound(arr)
- If InStr(arr(i, 1), "月") Then
- ReDim Preserve arrtemp(0 To 1, 0 To k)
- arrStr = Split(arr(i, 1), ".")
- arrtemp(0, k) = Trim(arrStr(0))
- arrtemp(1, k) = Trim(arrStr(1))
- k = k + 2
- End If
- Next
- Set ws = ThisWorkbook.Sheets("Sheet2")
-
- With ws
- .Cells.Clear
- .Cells(1, 1).Resize(UBound(arrtemp, 2) + 1, 2) = _
- Application.WorksheetFunction.Transpose(arrtemp)
- End With
- MsgBox "Done!"
- ws.Activate
- End Sub
复制代码
|
评分
-
1
查看全部评分
-
|