Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

###Error 57121###

74 views
Skip to first unread message

Jimmy

unread,
Nov 10, 2004, 8:33:02 AM11/10/04
to
Hi folks,

I don’t 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 piece’s 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.

Don Guillett

unread,
Nov 10, 2004, 8:47:11 AM11/10/04
to
Surely, there is more than this. You need not select. and do you really need
to goto 2000

For Each Cel In Worksheets("AllTeams").Range("A2:AB2000")
'what do you want to do with each cell
next cel

--
Don Guillett
SalesAid Software
don...@281.com
"Jimmy" <Ji...@discussions.microsoft.com> wrote in message
news:0692EF9F-CAA7-4D76...@microsoft.com...

keepITcool

unread,
Nov 10, 2004, 9:00:03 AM11/10/04
to
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 :

0 new messages