How to delete an entire Row that contains certain information

[Nuccio92]

I am trying to delete an entire Row from a specific sheet by just clicking a button that will run a macro. So on sheet 'Example' in cells A4 and B4, will have the sheet name and Account # respectfully. The macro would go to the sheet named in A4 and look in column B for a row that has has the same as B4 and delete the row. The Macro I wrote does not work properly.

Please Login or Register  to view this content.

[stnkynts]

If you want a single delete

Please Login or Register  to view this content.

If you want all values deleted

Please Login or Register  to view this content.

[Nuccio92]

Thank you that worked perfect. Is there a way to do the same thing but instead of deleting the row, cutting the row and then pasting it to the bottom of the list?