Hi David,

"David McRitchie" wrote in message
...
Hi Norman,
You coding tester and demo certainly work including variations,
don't know why I had problems before. Also the other posting I
referred to turned out to be in this same thread, no wonder they
addressed the same question.

Thank you for your reply.

The only circumstance in which the code:

With rng
.Value = .Value
End With

should fail is if rng represents a multi-area range. Perhaps that is how
you tested it.

Of course, the PasteSpecial method, which you suggested as an alternative,
will also fail if applied to a multi-area range.

---
Regards,
Norman