Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Abbie Cohen   on Jan 14 In MS Office Category.

  
Question Answered By: Silvia Chapman   on Jan 14

Just make a subtle change in your code.

Remove " ActiveSheet.Next.Select" from your program. At the beginning of
your For Loop add  this: " Sheets(counter).Select"

This will start at index 1 (each sheet is indexed starting at 1) and
work its way to the maximum amount of sheets  within the workbook.

Share: 

 

This Question has 9 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Selection Method of Worksheet class failed Or get search suggestion and latest updates.


Tagged: