Hi All,

i was running a macro which worked fine but i am suddenly getting an error where it gives an error 1004 --"Copy area and paste area are not the same shape or size"

it is frustrating the life out of me and i am not sure how to fix

Workbooks.Add ' Open a new workbook
ActiveWorkbook.SaveAs "GRC Weekly.xlsx"
Workbooks("EGCalendar 2010_1.xlsx").Worksheets("Open Project").Range("A:A,W:W,B:B,D:D").Copy _
Destination:=Workbooks("GRC Weekly.xlsx").Worksheets("Sheet1").Range("A1")
i really need this to open on separate workbook as i have setup....i changed it to open on a new sheet within the same workbook and it runs fine...

can any1 point me in the right direction please