Autofilter code and assigning Criteria1 equal to value of workshee
 

Hi,

How can I assign the "Criteria1" parameter below to the value of the
worksheet name? The value for the worksheet is always changing. I've assigned
this value to "Worksheet.Name". Below is the code and the "Criteria1"
parameter that I need to assign to the Worksheet.Name value.

Selection.AutoFilter Field:=1, Criteria1:="=242310400", Operator:=xlAnd
Application.CutCopyMode = False

Thanks in advance!
--
Kent Lysell
Financial Consultant
Ottawa, Ontario
W: 613.948-9557