Filter data based on Cell Value - ">" Syntax required

[Tracey]

Hi All,

I have found the following code to AutoFilter based on the value of a
certain cell:-

Criteria1:=Worksheets(1).Range("E9").Value (Thks to Tom Olgivie!!)

Can anybody provide the correct syntax required to change this code to be
the equivalent of a "greater than" filter instead of the "equal to" that it
is currently?

 

[JBeaucaire]

Try this:

Criteria1:=">=" & Worksheets(1).Range("E9").Value

Does that work for you?

 

[Jacob Skaria]

Criteria1:=">" & Worksheets(1).Range("E9").Value

 

[Tracey]

Now works a treat -- thanks to both of you !!