Counting nonblank cells

Please Login or Register  to view this content.

I've demonstrated the intended output on the sample worksheet. Counts are variable. In case the pseudocode is unclear, the goal is to count the number of components in each test.

lrr count example for vba.xlsx

Maybe:

Please Login or Register  to view this content.

Wow!!!! That worked fantastically. Thanks man.

You're welcome. Glad to hear that and thanks for the feedback!!