At first, thanks for the suggestion. I solved the Problem, which im working on 2 days now.
I removed the error handler and saw, that the Cells-Method wasn't able to be executed. I had to add the activesheet-object, so it can adress the right sheet, because the code opens a workbook and closees it in each round.
Thank you very much, because in other forums nobody even responsed.
|