Hi,

I want to clear some cells within another sheet when a button is pressed on a different sheet, the code i have so far is:

Sheets("February Stats").Select
ActiveSheet.Range("C8:R63").Select
Selection.ClearContents

But this obviously takes u into that sheet before deleting, so I then have put a bit of code at the end that takes me back.

Is there a way to clear cells in another sheet, without having to actually select it?

Thanks

Andy