bensonsearch
Well-known Member
- Joined
- May 26, 2011
- Messages
- 844
I have the below code
tempc is the value of the box ie 3, tempc is also a integer
the filter works fine but if there is no 3 in the field it returns ALL records. any ideas why?
Code:
If ComboBox3.value <> "" Then
Worksheets("Sheet3").Range("A1:P" & lastrow).AutoFilter _
Field:=9, Criteria1:=">=" & tempc
End If
tempc is the value of the box ie 3, tempc is also a integer
the filter works fine but if there is no 3 in the field it returns ALL records. any ideas why?