Pass range as variable to Range function

[souvick]

Hi,

I have to write a VBA to copy a hyperlink to a destination cell.

Hyperlinks are in Column A from A1:A5 say

My macro should copy the cell A1 to say destination cell E7.

Now for that please find the code below:

Please Login or Register  to view this content.

This code throws error as it is not able to process Range(myRange) and if I change that to Range("A1") this works fine.

But I need to dynamically select the cells as the hyperlink can be in any cell of A column so it should be the cell that I click on.

Secondly I need this macro to link with On Click event of that cell. How do I do that?

Please help.

Kind Regards
Paul

[souvick]

Hi,

This has been solved but by another method.

Please find the code below

Please Login or Register  to view this content.

[romperstomper]

FWIW, in your original code, this:

Please Login or Register  to view this content.

should have been:

Please Login or Register  to view this content.