Hey Excel experts out there,

I just started 2 days ago with some programming and most of it works, but one error I just can't get away: The following code always works the 1st time, but directly applying it again a 2nd time gives me an runtime error 1004 saying the pastespecial method of the range-object can't be executed. When I enable Option Explicit, it always gives an error there but doesn't tell me where to search.

All the code shall do is to copy 31 cells from the one very hidden and cell-protected file (quelle) to another one (ziel) (both into/ from the same position: "D1:D31" and both into/from the same Sheet: "Dropdown")

The code is:
Please Login or Register  to view this content.
Thank you guys!