Forum Discussion

Copper Contributor

Mar 20, 2019

VBA to filter multiple ranges in single column

Hi, I had a macro created which filters different groups of numbers from a within a possible range (35000-39999) in a single column and copied the filtered lines to a new tab. this works on a loo...

excel

Macros and VBA

Rajeev_Raghavan

Copper Contributor

Dec 15, 2019

ActiveSheet.Range("$A$1:$AT$670").AutoFilter Field:=8, Operator:=xlFilterValues, Criteria1:=Array("=7*", "=6*")

need to add "=9*" help me to find out the solution