How do you input user defined variables into an AutoFilter statement?

**trhoades** · 07-14-2010, 10:56 PM

I am trying to create a macro which allows a user to input a begining date and ending date which in then input into the macro to select rows for coping and pasting to a new sheet.

I think I'm close with the following code. The problem is I do not know how to call the Variables into the Criteria for the AutoFilter.

Please Login or Register  to view this content.

Any help would be much appreciated.

Tony

**Leith Ross** · 07-14-2010, 11:11 PM

Hello Tony,

I made the changes in bold.

Please Login or Register  to view this content.

**trhoades** · 07-14-2010, 11:23 PM

Leith thank you for your suggestion but I must be doing something wrong. When I make the changes suggested I get the following error:

ActiveSheet.Range("$A$1:$F$45").AutoFilter Field:=1, Criteria1:= _
">=" & MyInput1", Operator:=xlAnd, Criteria2:="<=" & MyInput2"

I receive a compile error?

Any suggestions as to what I may be doing wrong?