Excel VBA - Filter by Date and return the number of visible rows

  • Hi team,


    I've create a long macro to filter by Date and return the number of visible rows - however this is not working somehow.


    Also, I want my code to be shorter if possible.


    Could you please help me to generate a better code?


    I have attached 2 files - One to run the macro and one for Sample Data Book.






    Thank you!

  • Hello,


    Could you explain ... in plain English ... your final objective ???


    If it is to produce the Recap shown ... have you tried to Insert a Pivot Table ?

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)