Thread: vba help please
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Coyote[_2_] Coyote[_2_] is offline
external usenet poster
 
Posts: 10
Default vba help please

runtime error #9
subscript out of range


-----Original Message-----
What is the text in that dialog box before you click the

debug
button?

Ray at work

"Coyote" wrote in

message
...
I get the standard error dialog box where I press the
debug button and the statement is highlighted in yellow.

Is that what you mena??
-----Original 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



.



.