2018-01-01から1年間の記事一覧
Sub midashi() Range("B3:D15").AutoFilter _ Field:=2, _ Operator:=xlFilterValues, _ Criteria1:=Array("あああ", "") Range("B3:D15").AutoFilter _ Field:=3, _ Operator:=xlFilterValues, _ Criteria1:=Array("10", "15")End Sub
Sub midashi() Range("B3:D15").AutoFilter _ Field:=2, _ Operator:=xlFilterValues, _ Criteria1:=Array("あああ", "") Range("B3:D15").AutoFilter _ Field:=3, _ Operator:=xlFilterValues, _ Criteria1:=Array("10", "15")End Sub