RunTime Error 57121

M

Mike H.

When running a macro that is called from the workbook open area. The called
macro is in module 1, sometimes users get this error: runtime error 57121,
Application-defined or object-defined error. Any ideas why I get this. I
can't get rid of the error except to end execution. The line stuck on is:

Sheets("TransferHeader").Select
 
J

Jim Thomlinson

Is the sheet possibly hidden? You can not select a hidden sheet.
try this...

with Sheets("TransferHeader")
.Visible = xlSheetVisible
.Select
End With
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error Number 57121 5
Runtime error 57121 5
Excel 2003 Runtime error 40036 6
Working outlook via vba code with xlsx - error 0
VBA Assigning cell value to variable giving runtime error 3
Runtime error 57121 2
Macro Runtime errors 8
worksheets.select doesn't work 4

Top