.
Paste the code in the Sheet module, of the sheet you want it applied to.

It functions automatically when a row is deleted. You won't have to do anything.

This line in the code : For I = 1 To 50 can be changed if you want the number
of affected rows changed. For example, if you want it applied to 100 rows, change the
50 to 100. If want it applied to just the first 20 rows, change the 50 to 20.