Thanks Graham but it's still the same when I replace my code with yours.

As you say, there's no good reason from the clip I've posted. There's a lot of other VBA that gets processed before and my feeling is that the macro somehow gets ahead of itself. I'm going to try switching off multi-threading although I'm not sure if I'd be able to do that for the users.