VBA Confirm Message Before Deleting Row

[mackypogi]

It deletes. Try yourself first.

You are right sir, It deletes the rows. the problem is, I will get alot of confirmation button if I select many worksheets/tab.

For Example: Im going to delete 'try'

in Sheet1 : try

MsgBox1 : would you like to delete (1) rows?

in Sheet2 : try try

MsgBox2 : would you like to delete (2) rows?

in Sheet3: try try try

MsgBox3 : would you like to delete (3) rows?

Last MsgBox
MsgBox4 : number of deleted rows (6)