How to delete the last unwanted rows

Hello,

I have Sorted list of data with serial numbers. My task is to identify the last serial number which is 8 in the below and delete all the rows to the end after the last serial number. Can anyone look if it can be done using a VBA?


S.NO
1
2
3
4
5
6
7
8
BRANCH-NAME
CONDITION IS DISPLAYED FOR
CONDITION IS DISPLAYED FOR
CUSTOMER-NAME
CUSTOMER-NAME
LIST
LIST

Regards,

Zaska