dynamic date range filter from cell value in vba

I have a work book linked to an external data source, and would like to sort the data using dynamic date ranges from a drop down list in a cell.

I've tried everything I can think of to make the code work.

Currently I have a drop-down list in cell C13 and a vlookup formula that returns xlFilterYesterday

Here is the code that doesn't work

PHP Code: 

ActiveSheet.ListObjects("Table_SalesLineItems11").Range. _
        AutoFilter Field:=1, Criteria1:=Range("C12"), Operator:=xlFilterDynamic 


Here is the original code I have where I have several button on the worksheet making things complicated.

PHP Code: 

ActiveSheet.ListObjects("Table_SalesLineItems11").Range. _
        AutoFilter Field:=1, Criteria1:=xlFilterYesterday, Operator:=xlFilterDynamic 


I also hoping this will cut down the amount of code I have in the Module significantly.

Any help would be greatly appreciated.

Thanks,

Rusty

Use the value, 2.

Thank you for your reply...

Could you please elaborate a little more? I must be missing something.

Thanks,

Thanks I appreciate the help!