On Error Resume Next ' keep going on an error If anyone can help me out I would be grateful Error: Object variable or With clock variable not set.Error: Invalid Procedure call or Argument.The middle of three resources seems to be missed out - I suspect some error is happening which results in the loop being abandoned.I have tried many types of paste and they either result in a picture including the Gantt chart being pasted in or nothing happens. I have been using some code I produced a very long time ago which didn't have to iterate and open and close many Excel files and I wonder if this is what is giving me trouble. This is all being done for each resource in the project plan (there are three at the moment). Apply a filter in MSP and copy the contents.I am attempting to produce some VBA in MS project to:
