Range.clear does not work

[Jan Lichtenbelt]

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

[AB33]

The syntax is correct. The error might be somewhere else in the code.

[Jan Lichtenbelt]

I have the same problem if I program it just as one line in the Direct Window (Ctrl+G). That means it can not be due to other codes.

[AB33]

I do not see an error. Do you have merged cells?

[LordLoki]

I guess you have that macro in your personal Macro Book or in a workbook other than the one where the FirstSheet is in so make it

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

Also make Sure that you have the name of the Sheet written correctly the error seems to be cause the sheet can not be found.

[xlnitwit]

Hi,

You haven't specified the sheet for the Cells:

Please Login or Register  to view this content.

You can also use a With block or a variable to make the code neater.

[Jan Lichtenbelt]

Ok, the last one works correctly.

Thanks a lot!

Jan Lichtenbelt

[shg]

Or

Please Login or Register  to view this content.

[Winon]

Make sure the sheet/s are not protected.