Ask Your Question

ZOMGface's profile - activity

2013-08-31 18:47:45 +0200 received badge  Popular Question (source)
2013-08-31 18:47:45 +0200 received badge  Notable Question (source)
2013-08-31 18:47:45 +0200 received badge  Famous Question (source)
2013-01-23 16:50:35 +0200 asked a question 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?