Autofilter with multiple criteria - how to ignore blank criteria

Hi,

I have the following code:

Please Login or Register  to view this content.

However it requires all cell ranges , C2, D2, and E2 to have a value to filter or it displays blank lines only. How do you adjust the above code to allow it to ignore a cell if there is no search criteria entered into it?

Thanks

Perfect, thank you very much. Happy New year!!!!!!