excel in XP and Win 7

[Trantor]

I have a code which runs perfectly in XP but fails in Win 7
Both of the them are running Excel 2007

Sheets("ShtA").Range("$A$2:$K$" & last_R).AutoFilter Field:=2, Criteria1:= ">=" & Sheets("ShtB").Range("F3").Value, Operator:=xlAnd, Criteria2:="<=" & Sheets("ShtB").Range("G3").Value

My second column of ShtA contains date and time. F3 and G3 in ShtB are two criteria. Is there anything wrong with my code? Thanks.

 

[Trantor]

last_R stores the last row number of ShtA.