ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Errors with : Sheets(shArr).Select (https://www.excelbanter.com/excel-programming/427427-errors-sheets-sharr-select.html)

J.W. Aldridge

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