Thread: Printing
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob[_44_] Bob[_44_] is offline
external usenet poster
 
Posts: 6
Default 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!