Thread: How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
Dmitry Dmitry is offline
external usenet poster
  
Posts: 32
Default How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook?
Hello
How to repeat a code for selected sheets (or a contiguous range of sheets)
in a Workbook?
The code is:
Range("J16").Select
SolverOk SetCell:="$J$16", MaxMinVal:=1, ValueOf:="0",
ByChange:="$F$4:$I$12"
SolverSolve UserFinish:=True


Reply With QuoteReply With Quote