Hyperlink With Dynamic Cell Reference to Run Macro

Hi All,

I'm trying to solve an issue that I've been scratching my head for some time trying to figure out.

I have a sheet where I am calling a macro using a hyperlink. I have got it to call the macro fine, and the hyperlink points to the same cell. The issue I have is that if I insert or remove rows, the hyperlink no longer points to the same cell, and I would like it to. I also have another macro that duplicates the column with this hyperlink in in the adjacent column; however the hyperlink will always point to the original cell as it is not relative / dynamic.

I know that you can insert hyperlinks as a formula, which would be fine and would make them dynamic; however when you insert the hyperlink in this fashion, it no longer calls the macro.

Has anyone had this issue or know of a workaround?

Thanks in advance.

Sorry guys - just a little nudge to see if anyone is able to assist here.

Thanks in advance.