VBA - Copy Data from ActiveWorkbook to sheet in a diffrent WorkBook

[Browneh89]

Hey, I am having trouble getting some VBA macro code to work. I am attempting to copy a sheet of data from my active workbook to a sheet in a separate workbook. below are the lines of code I have been trying to get to work:

ActiveWorkbook.Worksheets("Layout - ED").Range("A1:R3500").Copy
Workbooks.Open ("C:\Users\Daniel\Desktop\Work 2\FINDER.xlsx")
Workbooks("FINDER.xlsx").Worksheets("Sheet2").Range("A1")

Whenever I run this though I get a debug error saying Runtime error '438' Object does not support this property or method. Can anyone give me some advice on how to fix this and what that error means and why the above code didn't work? (Sorry for all the questions I'm trying to learn :D)

 

[ravishankar]

try

[COLOR=#333333]Workbooks("FINDER.xlsx").Worksheets("Sheet2").Range("A1").pastespecial

ravishankar[/COLOR]