Macro runs without listing all entries H:H>0

Berry Metzger
Berry Metzger used Ask the Experts™
on
Hello Experts,
CreateSummary does not pick up all entries on each worksheet where column H>0.
For instance, using the date 8/20 in D1, on sheet WB(15) it skips cell H10 (value=6) and cell H30 (value=27) ; on sheet PL(25) it  skips cell H56 (value=6); however, on sheet PR(35) it picks up every entry H:H>0

@sktneer, originator, may have an insight on what may cause the inconsistency of results.
Thanks in advance,
Berry
SummarizeEntriesGreaterThan0ColumnH.xlsm
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2016
Commented:
HI,

pls change

If WorksheetFunction.CountIf(cell.Offset(0, 1).Resize(1, 10), myDate) > 0 Then

Open in new window

into
If WorksheetFunction.CountIf(cell.Offset(0, 1).Resize(1, 80), myDate) > 0 Then

Open in new window

Regards
Berry MetzgerLean process improvement consultant

Author

Commented:
That solved what was a perplexing, seemingly random error!
Thanks so much.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial