Is the workbook open? If not, open it.

Perhaps you have misspelled the workbook name or the worksheet name or either
does not exist?

The two lines should be one line.

Try a continuation character

Application.Workbooks("research.xls").Worksheets _
("sheet1").Range("a1").ClearContents


Gord Dibben Excel MVP

On Thu, 30 Dec 2004 12:12:34 -0800, "Coyote"
wrote:

vba editor does not like something about this????


Sub Macro1()



Application.Workbooks("research.xls").Worksheet s
("sheet1").Range("a1").ClearContents

End Sub