|
本帖最后由 一指禅62 于 2019-4-20 19:49 编辑
- Sub 查询()
- Dim arr, i&, j%, key$, a(), n&, x%
- arr = Sheet2.Range("A1").CurrentRegion
- key = Sheet1.Range("E4")
- If key = "" Then MsgBox "请输入订单号!": Exit Sub
- For i = 4 To UBound(arr)
- If arr(i, 11) = key Then
- n = n + 1: ReDim Preserve a(1 To 8, 1 To n)
- If n = 1 Then x = i
- a(1, n) = n: a(8, n) = arr(i, 12)
- For j = 2 To 7
- a(j, n) = arr(i, j)
- Next
- End If
- Next
- Application.ScreenUpdating = False
- With Sheet1.Range("A6:H10000")
- .ClearContents
- .Borders.LineStyle = xlNone
- End With
- If n > 0 Then
- Sheet1.Range("B4:D4") = Array(arr(x, 10), arr(x, 8), arr(x, 9))
- With Sheet1.Range("A6").Resize(n, 8)
- .Value = WorksheetFunction.Transpose(a)
- .Borders.LineStyle = xlContinuous
- End With
- Else
- MsgBox "没有这个订单号!"
- End If
- Application.ScreenUpdating = True
- End Sub
复制代码
|
评分
-
1
查看全部评分
-
|