Filter data based on Cell Value - "" Syntax required
 

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?
--
Tracey @ BrisVegas

Filter data based on Cell Value - "" Syntax required
 

Try this:

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

Does that work for you?
--
"Actually, I *am* a rocket scientist." -- JB
(www.MadRocketScientist.com)

Your feedback is appreciated, click YES if this post helped you.


"Tracey" wrote:

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?
--
Tracey @ BrisVegas

Filter data based on Cell Value - "" Syntax required
 

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

"Tracey" wrote:

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?
--
Tracey @ BrisVegas

Filter data based on Cell Value - "" Syntax required
 

Now works a treat -- thanks to both of you !!
--
Tracey @ BrisVegas