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

asked 2013-01-23 16:50:35 +0100

ZOMGface gravatar image

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?

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by manj_k
close date 2014-07-05 20:47:55.669952



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.

JohnSUN gravatar imageJohnSUN ( 2013-01-24 09:36:35 +0100 )edit

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

qubit gravatar imagequbit ( 2013-03-12 11:28:15 +0100 )edit