Thread: Macro for solver on certain worksheets
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Dberry Dberry is offline
external usenet poster
  
Posts: 1
Default Macro for solver on certain worksheets
On Thursday, February 16, 2012 8:17:09 AM UTC-5, merjet wrote:
Yes. Before the code you have now insert Sheets("Sheet2").Activate or

Sheets("Sheet2").Select. Then repeat the code but replace "Sheet2"

with "Sheet3". If you plan to expand to several worksheets, then embed

the Solver code in a loop.

Can you please demonstrate the code to create a loop for multiple sheets?
Reply With QuoteReply With Quote