|
本帖最后由 opel-wong 于 2019-10-12 17:55 编辑
这会刚好有空,顺手写了一个,
请测试:- Sub 宏1()
- Dim brr, mRow As Long, Rng As Range
- With Sheet1
- brr = Selection
- If (UBound(brr) - LBound(brr) + 1) * (UBound(brr, 2) - LBound(brr, 2) + 1) <> 6 Then MsgBox "错误选择,请重新操作!", 16 + 0, "提醒": Exit Sub
- mRow = .Cells(.Rows.Count, 1).End(3).Row
- Set Rng = .Range("A1:B" & mRow)
- .AutoFilterMode = False
- If .FilterMode = True Then .ShowAllData
- Rng.AutoFilter Field:=1, Criteria1:=brr(2, 1) ' 订单
- Rng.AutoFilter Field:=2, Criteria1:=brr(2, 2) ' 物料
- .Range("b2:b" & mRow).Replace "*", brr(2, 3) ' 替换物料
- End With
- End Sub
复制代码
|
评分
-
2
查看全部评分
-
|