VBA Counting cells based on date range

I have a code that gives the count of cells matching certain results, like date range, and few specific “text”.

The problem is, I’m not getting the correct count when this code is run. The result is less by 8 or 9. Example if the source has 100 cells matching my condition, I get only 90 as the output.

The code will be in the userform. “Latency” is the source sheet and “WBR45” is the destination sheet , CAn you please tell what is the mistake here?

Top Contributor Asked on January 16, 2017 in VBA: User Forms.
Add Comment
2 Answer(s)


Please share your sample workbook  at info@analysistabs.com


Expert Answered on January 16, 2017.
Add Comment

Thanks for the reply and ur time 🙂 I found the answer to this 🙂

Top Contributor Answered on January 16, 2017.
Add Comment
  • Found this useful?

    Please share using the share button above.

    If you found the answer is best answer for your question, Please mark as 'best answer' by clicking on the right tick mark icon at the left side of the answer.

    Found the answer useful and wants to credit the user, then vote the answer (vote up).

  • Your Answer

    By posting your answer, you agree to the privacy policy and terms of service.