I'm trying to copy data between workbooks, but i'm getting an 1004 run time error, on the range object that i'm using viz.
Workbooks("Origin.xlsx").Worksheets("Data").Range(Cells(1, 1), Cells(lastrow, lastcol)).Copy Workbooks("Destination.xlsx").Worksheets("Copy").Range("A1")
I have the codes below to basically copy and paste some data from one workbook (book23) to other workbooks.
the problem is that sheet "WDed15" may not exist. Can someone show me how to add an if statement to test if sheet("WDed15") exists, if it does, continue to execute the entire...