|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
- Sub test()
- Dim wb As Workbook, sh As Worksheet, rng As Range
- Workbooks.Open ThisWorkbook.Path & "\表1.xlsx"
- Set wb = Workbooks("表1.xlsx")
- Set sh = wb.Sheets(1)
- Set rng = sh.Range("A1:A19")
- ThisWorkbook.Activate
- Dim i, j, s, str$, arr()
- str = "RRR"
- ReDim arr(1 To rng.Count, 1 To 5)
- For i = 2 To rng.Count
- If InStr(rng(i), str) And rng(i).Offset(0, 7) >= #11/1/2018# And rng(i).Offset(0, 7) <= #11/30/2018# Then
- s = s + 1
- arr(s, 1) = rng(i).Offset(0, 0) '发票号
- arr(s, 2) = rng(i).Offset(0, 1) '产品
- arr(s, 3) = rng(i).Offset(0, 2) '数量
- arr(s, 4) = rng(i).Offset(0, 5) '国家
- arr(s, 5) = rng(i).Offset(0, 7) '实际发货时间
- End If
- Next i
- Range("B2").Resize(s, 5) = arr
- wb.Close
- End Sub
复制代码 |
|