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