Sub Macro1() Remove all except validated ActiveSheet.Range('$A$1:$H$5202').AutoFilter field:=8, Criteria1:<>'Validated' Activesheet.
確定! 回上一頁