Hi Kirk,

Try something like:

'=============
Public Sub Tester002()
Dim WB1 As Workbook
Dim WB2 As Workbook
Dim SH As Worksheet

Set WB1 = Workbooks("Backup.xls") '<<==== CHANGE
Set WB2 = Workbooks("YourBook.xls") '<<==== CHANGE
Set SH = WB1.Sheets("MASTER") '<<==== CHANGE

SH.Copy Befo=WB2.Sheets(3)
End Sub
'<<=============



---
Regards,
Norman



"kirkm" wrote in message
...
I made a mistake and had to delete the sheet from my xls. Can I
import the sheet from a backup? Not the data - the whole sheet with
colours and formating as well..
Is that possible?

Thanks - Kirk