Selecting Range in non-active sheet
 

Hi,

Does anyone know how you can select a range in a sheet that is not the
currently active sheet, and then clear its contents.

I have tried:

Sheets("Sheetname").Cells.ClearContents etc etc but can't get it to
work,

Thanks,

Mike