Excel vba error message "Run Time error 1004: Select Method of Worksheet class failed"

[EverClear]

Hi there,

I have been successfully executing the same code for quite a while, but when I attempted to run my macro this time I received a "Run Time error 1004: Select Method of Worksheet class failed" error message, and the macro bombs...

What the macro is supposed to do is perform the same sequence of steps, starting on the 4th worksheet in the file, and loop through the steps to the last worksheet in the file.

This is the code that I have been using:

For i = 4 To Sheets.Count
Sheets(i).Select

' various steps...

Next

This code has not produced any error messages -- until now.

Any ideas of how I could change this code would be appreciated. Thank you!!

 

[JoeMo]

Hi there,

I have been successfully executing the same code for quite a while, but when I attempted to run my macro this time I received a "Run Time error 1004: Select Method of Worksheet class failed" error message, and the macro bombs...

What the macro is supposed to do is perform the same sequence of steps, starting on the 4th worksheet in the file, and loop through the steps to the last worksheet in the file.

This is the code that I have been using:

For i = 4 To Sheets.Count
Sheets(i).Select

' various steps...

Next

This code has not produced any error messages -- until now.

Any ideas of how I could change this code would be appreciated. Thank you!!

Assuming you have at least 4 sheets in your workbook and that the error is in this line:
Sheets(i).Select
a guess would be that the sheet is hidden.

 

[EverClear]

Holy cow!! You're right. THANK YOU!!!!!

 

[JoeMo]

Holy cow!! You're right. THANK YOU!!!!!

You are welcome - thanks for the reply.