Hi
try
worksheets("other_sheet_name").range("A1:B20").cle arcontents

--
Regards
Frank Kabel
Frankfurt, Germany

Tim Kelley wrote:
I need to clear a range of cells in a different worksheet than is the
activesheet. Is there a way to set what worksheet is the current
sheet?

Thanks