用数组写入,但是数据不带格式- Sub demo()
- Dim strTxt$, iRow%, i%, j%, arr, brr(1 To 50000, 1 To 20)
- With ThisWorkbook
- strTxt = Application.Phonetic(.Sheets("主店").Range("A2").CurrentRegion.Offset(1, 0))
- With .Sheets("费用")
- arr = .Range("A2:T" & .Cells(Rows.Count, 1).End(xlUp).Row)
- For i = LBound(arr, 1) To UBound(arr, 1)
- If InStr(strTxt, arr(i, 1)) Then
- iRow = iRow + 1
- brr(iRow, 1) = arr(i, 1)
- For j = 2 To 20
- brr(iRow, j) = -arr(i, j)
- Next
- End If
- Next
- End With
- .Sheets("提取转换表").Range("A1").CurrentRegion.Offset(1, 0).Clear
- .Sheets("提取转换表").Range("A2").Resize(iRow, 20) = brr
- End With
- End Sub
复制代码 |