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. |
All times are GMT +1. The time now is 11:30 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com