The code assigns the first visible cell in column A to a variable. You can do whatever you want with that variable afterwards. It does not matter whether cells are manually hidden or filtered.

Hi,

many thanks for the help! That code of yours might prove useful going forward - hidden cells are not so uncommon.
In this case, however, they are only filtered for reasons I know now - and further down, there are more lines which are filtered. By use of another formula inbetween and a COUNTIFS, it works fine now.
It's probably not the most elegant or slimmest possible routine, but it works, that is the target.

Best regards,

Officer_Bierschnitt