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
|