Are you still using this version of your code?

gaba wrote:

Well, I have the destination cells linking to the original cell with this
piece of code

With Cells(DestRow, DestCol + 1)
c.Copy
.PasteSpecial Paste:=xlPasteValues
.Value = c.Value
ActiveSheet.Paste Link:=True
Application.CutCopyMode = False
.NumberFormat = c.NumberFormat
.Interior.ColorIndex = 8
End With

Now it goes to the last column and stops the loop. I think is something to
do with the ActiveCell going somewhere else... Oh Boy, one fixed and the rest
destroyed...

Does anybody see Why?
Thanks
Gaba

--

Dave Peterson