Paste links instead of values

[internet_imran]

Hi friends,

Please help me i want to paste links instead of values on following line based on column J.

.Range("J" & LR1).Value = ws.Range("J" & cel.Row).Value

Please Login or Register  to view this content.

Thanks

imran

[LeoTaxi]

maybe change to this ?

Please Login or Register  to view this content.

kind regards
Leo

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[internet_imran]

Hi John H.Davis
the solution provided by you show error specified file not open when clicked on the link cell.

Following code line my be match to the solution but this not worked, and i cant understand this.

Please Login or Register  to view this content.

Thanks
imran

[internet_imran]

Cheers!!!!!!!!!

I do it.
Solution

Please Login or Register  to view this content.