[RESOLVED] How to delete row (VBA Excel)..pls help

Dear Expert,

How to delete rows please..???..when everytime I click "Delete Row" button, it will delete one current row..and so on...BUT when it has no more row to delete, it will show up a pop up message....Has anyone knows how to put the code please...???

Herewith, I attached my latest excel file in zip file for your reviews :wave:

Thank you for your kind helps,,, ;)

This is what you asked for, plus the form resets when all rows are deleted. :afrog:

Thank you so much for your reply...and kind helps :)