checked spelling and made sure both exist.

error says subscript out of range

error #9
-----Original Message-----
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").Worksheet s _
("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").Workshee ts
("sheet1").Range("a1").ClearContents

End Sub

.