Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

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?