VBA Confirm Message Before Deleting Row

[mackypogi]

Hi Admin

The code works! thank you so much for your fast response. while exploring it more, I found another problem.

The code loops through different/multiple worksheet that is selected by the user. but using your provided codes when I delete rows from different or MULTIPLE SELECTED WORKSHEETS it only compute the total number of rows in each worksheet. not the total number of rows deleted. You can try it yourself, try to select multiple worksheet and use the macro to delete. Sorry I cannot provide anymore Images. I dont know what happened. I cannot upload anymore

The problem is with the confirmation MsgBox again. It can only display the total number of rows in each worksheet. but not the total number of rows that should be deleted.

for example:

in Sheet1

MsgBox1 : would you like to delete (1) rows

in Sheet2

MsgBox2 : would you like to delete (2) rows

in Sheet3

MsgBox3 : would you like to delete (3) rows

Last MsgBox
MsgBox4 : number of deleted rows (6)