Jimmy.
in your code the
Worksheets("AllTeams") is unqualified = e.g. the workbook is
unspecified, so VBA will use the Activeworkbook.
If your user has a workbook activated that doesn't have the
worksheet.. then this error will popup.
--
keepITcool
|
www.XLsupport.com | keepITcool chello nl | amsterdam
Jimmy wrote :
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.