Delete filtered (visible) row but not heading

[mhoude]

Hi,

I have a big file which i filter multiple times to delete rows.

I cant find a way to delete just visible row but not heading

Here is part of the code:

Please Login or Register  to view this content.

Help please

[AlphaFrog]

Try something like this...

Please Login or Register  to view this content.

[mhoude]

Thanks you. Will try it tomorrow morning. I'll come back on it.

[mhoude]

Thank you, work well, exept when there's no visible cells.

[AlphaFrog]

Thank you, work well, exept when there's no visible cells.

This will test if there is anything to filter...

Please Login or Register  to view this content.