Solved: Copy and Paste with Macros

[dimmutal]

Hi there. I use an expression of the form .Cells(i,2)=.Cells(i,3) to copy paste some data in Excel. However if data are HYPERLINKS then the copied data do not preserve the hyperlink but they are plain text. How can i copy data and preserve the hyperlinks? Thanks

[Norie]

Why don't you actually copy?


.Cells(i,2).Copy .Cells(i,3)

[dimmutal]

Because i have 4500 lines of data!!

[Norie]

Sorry I don't understand your reply.:)

Can we see the rest of the code?

[dimmutal]

Thanks. Quite simple. Silly of me!!

[Norie]

Could we actually see the code?

What you've posted implies that you're using a loop which might not be needed.

[dimmutal]

No thanks, its ok. I replied before without seeing the answer of Norie, so my problem is solved. How do i mark this topic as solved by the way?

[lucas]

Thread marked solved