Hi all,

I figured out what is goin on. There is a problem with the custom autofilter. When the first criteria is passed in column 2 all goes OK.
When I pass the second criteria from the custom filter with dates, it seems not to see the format (dd/mm/yyyy) and the rows are empty. When I run the macro step by step and when getting to the custom filter part and change it manually, it will work. Do I somthing wrong? is there a problem with the format? mabye I should pass somehow the format in the criteria1 and criteria2 from the field 1. I'm lost as much as it can.

Any help will get me out of this crazy situation.

Greetings.