What kind of file are you opening? And could you explain the processa little more? I see all kind of deletes, defining of headings (eachtime the VBA-sub runs?), formatting etc.