After clicking a hyperlink to a macro, is there a way to move the selected cell to where the hyperlink location is?

Basically, I need the following:

When I click cell D4, there’s a hyperlink to a macro that deletes the content of row 4

Now i need that row to be duplicated down say 10 rows, and EACH cell in the D column has a hyperlink to run the same macro.

If my selected cell is on row 6, and I click cell D3, I need the macro to delete row 3, NOT row 6.

Is there a way to, upon/after clicking the link to the macro, moving the cell selection (or active cell thingy) to the place i actually clicked that will be relative and work when I duplicate the rows, thus making lots of “delete” buttons?

Can you upload the short example of your workbook here? I hope that a solve of your problem can be very simple, but to create a sample file by your description is more complicated.

@ZOMGface – Are you still interested in finding an Answer to your question?