Does anyone know how to code this
I need to delete a bunch of rows but, the number of rows changes all the
time. I need to figure out a way to determine the number of rows that needs
to be deleted and delete them, at the same time shifting the other rows up.
All this has to be done by clicking a button.

Is there a o replace the 5 annd the 7 with variables representing numbers?
or is there any other way to accomplish the same task?

Any help will be greatly appreciated. Thank you.

Ayo

Worksheets(1).Rows("5: 7").Select
Selection.Delete Shift:=xlUp