Reply to thread

Message: [QUOTE="Norman Jones, post: 7003557"] Hi Lizzie45ie, I think there was a typo in Dave's response.I think he intended: Selection.AutoFilter Field:=37, _ Criteria1:=CLng(CDate(Starting)), _ Operator:=xlAnd, Criteria2:=CLng(CDate(Ending)) However, I think that you will also need to add the > and < operators, e.g.: Selection.AutoFilter Field:=37, _ Criteria1:=" >=" & CLng(CDate(Starting)), _ Operator:=xlAnd, _ Criteria2:="<=" & CLng(CDate(Ending)) Incidentally, with the Starting and Ending variables dimmed as dates, I was able to drop the CLng and CDate conversions when woking with a US date setup; If I used UK type (dd/mm/yy) date setings, then I needed the CLng conversions. In either case it will not hurt to use the conversions. [/QUOTE]