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

T

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?
 
J

JBeaucaire

Try this:

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

Does that work for you?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filter based on named range cell - debug help required 3
Cell Required before Closing 1
Conditional format if difference in cell values greater than 0.50% 1
Hide Co9lumns based on cell value 6
Loop to hide sheet based on cell 1
Update Pivot Table Filters based on a Cell Value in Excel 2007 0
using filter based on last column 6
If/Elseif AutoFilter Macro 4

Top