| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Only print worksheets with data in B2
copies:=1 should be on the same line as printout
sorry "ben" wrote: This was tested Sub printb2() For Each w In ThisWorkbook.Sheets If w.Range("b2") < "" Then w.PrintOut Copies:=1 Next End Sub "David D" wrote: Office 2003 I have created a workbook template with 31 worksheets and a main worksheet, I would like to press a command button from the main worksheet that will loop through all 31 sheets and send to the printer all sheets with data in the B2 cell. thanks in advance, David |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Certain worksheets won't print | Excel Discussion (Misc queries) | |||
| Need to print a workbook but worksheets have diff print areas | Excel Discussion (Misc queries) | |||
| How do I print a workbook in but only print selected worksheets? | Excel Discussion (Misc queries) | |||
| Pivot Table macro to set print area and print details of drill down data | Excel Discussion (Misc queries) | |||
| print out of worksheets | Excel Worksheet Functions | |||
Hybrid Mode
