| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Common range name for 2 sheets | Excel Discussion (Misc queries) | |||
| Macros for Protect/Unprotect all sheets in a workbook | Excel Discussion (Misc queries) | |||
| Dynamic named range across multiple sheets | Excel Discussion (Misc queries) | |||
| Copying multiple sheets from one book 2 another and undertake spec | Excel Discussion (Misc queries) | |||
| Stubborn toolbars in Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
