View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
J.W. Aldridge J.W. Aldridge is offline
external usenet poster
 
Posts: 425
Default 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.