|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
本帖最后由 yuhan4488 于 2021-10-25 20:50 编辑
不知道对不对- Sub del()
- Dim arr, brr, i, j, m, k
- arr = Sheet1.[A1].CurrentRegion
- brr = Sheet2.[A1].CurrentRegion
- For i = 1 To UBound(arr)
- For j = 1 To UBound(brr)
- If arr(i, 6) = brr(j, 4) Then Exit For
- Next
- If j = UBound(brr) + 1 Then
- m = m + 1
- For k = 1 To UBound(arr, 2)
- arr(m, k) = arr(i, k)
- Next
- End If
- Next
- Sheet3.UsedRange.NumberFormatLocal = "@"
- Sheet3.[A1].Resize(m, UBound(arr, 2)) = arr
- End Sub
复制代码
|
|