Avoid Clipboard and copy and paste

[ScottUlmer]

Hello,

I am trying to do something like:
Range(“B1").Value = Range(“A1").Value

I can get this to work, but I cannot get it to work across multiple workbooks. When I declare the workbooks and the sheets I end up getting Excel error 438. Any Idea why? How can I get around this?

 

[Norie]

What exactly did you try for multiple workbooks/sheets?

 

[ScottUlmer]

Worksheets("Sheet1").Range("A1:B10").Value = Windows("Book2").Worksheets("Copy Me").Range("A1:B10").Value

I tried with and without file extension
. I don't think my references are bad since I am not getting an error type 9 (I think that is the out of range error)

 

[Norie]

Did you try using Workbooks("Book2") and adding the file extensions for both workbooks?

Also, how are the 2 workbooks being opened and what's the actual error message?

 

[ScottUlmer]

Awesome thank you so much for the help! My issue was it should have been Worksheets not Windows. .