大家帮忙一下,把BH,BI,BR,不重复提取在BS到BU列,谢谢
- Sub 宏3()
- Application.ScreenUpdating = False
- Range("bh:bh").Copy Range("bs1")
- Range("bi:bi").Copy Range("bt1")
- Range("br:br").Copy Range("bu1")
- Range("bs:bu").RemoveDuplicates Columns:=Array(1, 2, 3), Header:=xlYes
- Application.ScreenUpdating = True
- End Sub
复制代码
|