Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing
I have a 20 sheet bid. I want to print half of each sheet if cell I55 is 0 print range if not then go to the next sheet check cell I87 is 0 print, or go to the next sheet and so on. What am I missing? The first sheet only works.
If [I55] 0 The Range("A52:I67").Selec Selection.PrintOu Els If [I87] 0 The Range("A84:I99").Selec Selection.PrintOu Els If [I119] 0 The Range("A116:I131").Selec Selection.PrintOu End I End I End I End Su Thank you for you help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 printing problem--printing 1 document on 2 pages | Excel Discussion (Misc queries) | |||
Excel Printing --Borders are not printing on the same page as data | Excel Discussion (Misc queries) | |||
Printing | Excel Discussion (Misc queries) | |||
Printing a heading on each new page when printing | Excel Discussion (Misc queries) | |||
Enable Double sided printing contiuously when printing multiple s. | Excel Discussion (Misc queries) |