Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Errors with : Sheets(shArr).Select
Have workbook with many codes... Several of them use this command.
I have been using this workbook for over an year. All of a sudden, each code has suddenly malfunctioned due to this command. I have ammended or changed each code to avoid using this command but very curious as to what would trigger this to become an issue. Error message is: Select method of sheets class failed. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to find and log all formula errors on all sheets | Excel Programming | |||
Graphing errors due to data from different sheets | Excel Discussion (Misc queries) | |||
End Select without Select Case, Block If without End If errors | Excel Programming | |||
Copying Sheets causes errors | Excel Discussion (Misc queries) | |||
add-in macro strange errors--method sheets of object workbook fail | Excel Programming |