button to del row

[MATT.B]

push button example.xls
I have attached my example what I'm looking to do is delete a row using a push button
so when they push the Delete button it will delete the row that button is on I don't know how to use the button to select what row i wish to delete
and i mean delete entire row not just the contents of the row.
my sheet usually has any where from 30-100 rows of data and each day 1-15 scattered rows gets deleted and 1-30 rows get added each day, so i would like this macro be a general macro that uses the button push as the row selector so I only have 1 macro with multiple buttons
push button example.xls

[JasperD]

It's easier to put one DEL button in the top of your sheet and then link it to the following macro:

Please Login or Register  to view this content.

If you push it, it will delete the row with the selected cell.
Enjoy

[MATT.B]

I get that that's easier but some times its 3 pages long I would have to scroll down select then back up they way I'm doing it now is faster than that but thanks for the help but your solution isn't what I'm looking for, I already have a tool bar button for that. I'm trying to simplify things for another users because they are screwing with my formulas by deleting the contents of the row and then copy and pasting the remaining rows up a line and I'm trying to prevent this from happening so I don't have to rewrite all my formulas on days I have off.

[JasperD]

Darn, you make me write two lines of code instead of my preferred one...

Please Login or Register  to view this content.

throw into a module on your sheet and it'll work.
It'll delete the row + the button.

[MATT.B]

That works great but I only see one issue with this. you cant undo the delete can the undo feature be enabled with this style of row delete or is it because I'm using a macro to do the work for me

[JasperD]

Hi Matt,

this cannot be undone, sorry.