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