Is that all on one line?

Do you have an open workbook Research.xls, which has a sheet names Sheet1?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Ray Costanzo [MVP]" <my first name at lane 34 dot commercial wrote in
message ...
What makes you think that it "does not like" that? Do you get an
error? If so, what does the error say?

Ray at work

"Coyote" wrote in message
...
vba editor does not like something about this????


Sub Macro1()



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

End Sub