It is a little difficult as I cannot seem to replicate the problem and the
user is on Excel 2003 too. I can't remember why I went with my original
method in the first place but having read all the replies and interesting
discussion I have tried Jim's.

Sheet1.Range("A:F").Value = Sheet1.Range("A:F").Value

I await what happens when tested by the user who gets the error.