Operators used in Macros

[newbie1234]

Hi there,

I need urgent help with my coding in Macro.. As you can see in Code 1 example Im trying to use an Autofilter to filter my cells with a Number Filter of is greater of equal to 4 and is less than or equal to 5.

But as you can see I would like to customise is using a range of 2 values which i have specified in Cell P1 and Q1.

I manage to figure out how to reference to this cell, but Im not sure how can i put my ">=" and "<=" operators into my code so i can get it to work exactly how i want as shown in Code 1.

Code 1

Selection.AutoFilter
ActiveSheet.Range("$A$1:$K$118").AutoFilter Field:=6, Criteria1:=">=4", _
Operator:=xlAnd, Criteria2:="<=5"

Code 2

Selection.AutoFilter
ActiveSheet.Range("$A$1:$K$118").AutoFilter Field:=6, Criteria1:=Range("P1").Value, _
Operator:=xlAnd, Criteria2:=Range("Q1").Value

Thanks in advance..

[newbie1234]

I did some trial and error and i solved it..

[martindwilson]

try
criteria:"<=" & Range("d1").Value