| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cutting down code
I have recorded a macro to print the same range on a series of sheets and
then return to first worksheet. Is there a way of cutting down on repetition in code. Please see example of what I have... Range("B328:L347").Select ActiveSheet.PageSetup.PrintArea = "$B$328:$L$347" Selection.PrintOut Copies:=1 ActiveSheet.Next.Select ActiveSheet.PageSetup.PrintArea = "$B$328:$L$347" Selection.PrintOut Copies:=1 ActiveSheet.Next.Select Range("B328:L347").Select ActiveSheet.PageSetup.PrintArea = "$B$328:$L$347" Thanks in advance, Aidan. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Redirection After Cutting | Excel Discussion (Misc queries) | |||
| Bar Cutting Optimization???? | Excel Programming | |||
| Cutting every other row from a spreadsheet | Excel Discussion (Misc queries) | |||
| cutting text | Excel Discussion (Misc queries) | |||
| Spinners aren't cutting it | Excel Programming | |||
Threaded Mode
