Hi Debaser,

what does that do? I don't want to paste anything yet.
The scenario is a bit different from what I thought, I didn't look close enough.
Those rows are not hidden, they are filtered because some cells are not populated.
In their manual count, the people in that dpt. currently do not include those filtered rows, so I also have to disregard those in my macro.

What I do in that worksheet is a COUNTIF() function. Ah - I'll try modifying that and using a COUNTIFS() and specifying as a second condition that the cells in that column must not be empty.

I'll keep you posted.