Thread: vba code help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
coyote coyote is offline
external usenet poster
 
Posts: 1
Default vba code help

Good morning,
What did I do wrong??

I have 2 files open in excel (1 instance). Book1 and
Book2. Running the following macro in Book1 results in an
error on the xxx line (Object doesn.t support this
property or method):

Sub test()

Dim xxx As String

xxx = Windows("book2").Worksheets("sheet1").Range
("a1").Value

End Sub