copy a hyperlink to another cell

[aya2002]

Hi friends,

Now i am tried for long time to copy the hyperlinks from a cells to another cells (column beside column) but without good results would you help me please?

thank you very much

[Eric B]

You need to click on the cell next the hyperlink and then hold down shift key. Use the arrow keys to move or b\navigate and then after the whole hyperlink is been highlighted leave the shift key. Now right click on the highlighted part and then click on Copy. After that select or choose nay of the empty cell or where you want right click on it and then paste.

[aya2002]

Thank you very much Eric B but i need a VBA code, would you help me?

tnaks