VBA in filtered data how to find the last and the first row?

[Elnur]

I have filtered data. and I need to delete all rows which meet do not meet my criteria. I want to find the last and the first row after filtering the data then delete those rows. Do you know how to do it? any help would be appreciated.

 

[Elnur]

which do not meet*

 

[Marc L]

The smart way is to filter only the rows to delete so select the opposite criteria …​