Sort Criteria

[apurk45]

ActiveSheet.Range("$A$20:$AG$600").AutoFilter Field:=32, Criteria1:=">120", Operator:=xlAnd

I would like to select the number of days (in this case is 120) for Criteria1:=">120" based on the value in M6 in Worksheet "E-Chart". In other words, some sorts will be based on 120 days, others will be based on 270 or something else.

I am stock on this one, any help will be greatly appreciated.

John

 

[dave3009]

Perhaps something like this:

Dim numDays as Integer
numDays = Sheets("E-Chart").Range("M6").Value
ActiveSheet.Range("$A$20:$AG$600").AutoFilter Field:=32, Criteria1:=">"&numDays, Operator:=xlAnd

 

[apurk45]

Sweet
Works perfect.
Thank you Dave