I want to clear a range of cells in more worksheets. If I use e.g.

Activesheet.Range(Cells(8,2),Cells(9,3)).clear

it works fine. But when I use a different worksheet like eg.

Sheets("FirstSheet").Range(Cells(8,2),Cells(9,3)).clear

I get the error message: Error 1004 "Application-defined or Object-defined error"

What to do?

With kind regards

Jan Lichtenbelt