Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.ScreenUpdating = False
If Range("a2") <> "" Then
Sheets("sheet1").Range("A1:E60000").AdvancedFilter Action:=xlFilterCopy, _
CriteriaRange:=Range("A1:A2"), CopyToRange:=Range("A4:E4"), Unique:=False
End If
End Sub
请高手帮忙解答 ,小弟感激不尽,谢谢作者: roych 时间: 2012-3-11 11:34
手动复制另存一份不算太难吧?为什么非要搞VBA呢?