VBA macros don't offer any interaction to select rows. You would have to define the rows to be deleted in the macro, and the macro would always delete the same rows in each table where you used it.
It's possible to create a macro that clears a set of selected rows, but that has no advantage over simply pressing the Delete key.