Hi all,

I have a problem in that when I copy and paste values from a block of cells (which had formulas in them) with paste special - values only in to another set of cells with formula the values are incorrectly calculated. It is obvious that the cells I have copied still have some underlying reference or formatting that impedes the latter formula calculating correctly. If I physically overwrite (type) the cells with the same value and paste it in to the new cells - it works. I have also tried copying and pasting the values in to a new sheet first then (paste special - values only) and then copying that and re-pasting (values only) them in to the new cells with no success.

Any help is most welcome.

Cheers,

Drew.