You can reference a worksheet cell in your AutoFilter code. For example:

ws.Range("A1").AutoFilter Field:=7, _
Criteria1:="=" & Range("K1").Value


Andre Anderson wrote:
Thanks so much it worked just fine. I keep your name for future help if
you don't mind. I realize that some people did some ground work before
me.

What about the second question, if you indulge me?

Can I reference a cell as a criteria in auto filter.

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html