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!
|