Hi folks,

I dont have much programming experience, but have cobbled together a
data collation model for several users. All have successfully used this with
the exception of one who keeps receiving the following error when attempting
to perform a number of actions : Run-time error 57121- Application-defined or
Object-defined error.

Here are a few pieces of code that are highlighted when the error occurs :

For Each Cell In Worksheets("AllTeams").Range("A2:AB2000")

Sheets("AllTeams").Select

Anybody suggest a cause for this error and any possible solutions?

Thanks

Jim.