type mismatch while trying to filter and copy rows and paste to another worksheet

[perducci]

I am trying to copy rows from a sheet to another sheet while filtering the rows by several criteria. I want to tell the program what column to look in on the first sheet and what value I want in that column. I use the following code to reference a module with a sub called "Copyrowsandpaste":

Please Login or Register  to view this content.

where S is the column and Completed is the desired value. The module functions when I have only one criteria:

Please Login or Register  to view this content.

But when I try to add other criteria, I get an error:

Please Login or Register  to view this content.

I get a type mismatch error. Any ideas how can I fix this error?


Thank you!

[perducci]

I attached the code to the first post! Please take a look!

[perducci]

I still need help with this one. Perhaps there is another solution??