Thread: Selecting sheets based on cell in each sheet
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steve Steve is offline
external usenet poster
  
Posts: 1,814
Default Selecting sheets based on cell in each sheet
If I have a "Yes" or "No" in say cell A1 of each sheet in a workbook. Is
there a way to select each sheet that has a "Yes" in cell A1? There could be
up to 100 sheets in the workbook. Thanks for any help.
Reply With QuoteReply With Quote