Hi Briers,

Sorry! My post was intended as a reponse to Chris but I
inadvertently appended it to the wrong strand.


---
Regards,
Norman


"Brizers" wrote in message
oups.com...
Apologies Norman, it was Chris who asked the question (I suggested an
answer). For reference, this was:

Range("First cell reference:Second cell reference").Clearcontents

e.g. Range("A1:B20").Clearcontents