I am using the following code, which works fine. The only issue is that the "SHEET3" name is not recognised after the first time the macro is run!
The macro saves the the names "SHEET3" but the next time it runs the sheet is not recognised??
Range("a1:q52").Select Range("a1:q52").Copy Application.ScreenUpdating = False Set wbopen = Workbooks.Open(Filename:="z:\Production Booking\weekly reference.xls") Sheets("SHEET3").Range("A65536").End(xlUp).Activate Range("a1:q52").PasteSpecial wbopen.Close SaveChanges:=True Application.ScreenUpdating = True
many thanks in advance