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! |
Printing
If Worksheets("1").Range("I55") 0 Then
Worksheets("1").Range("A52:I67").Select Selection.PrintOut Else If Worksheets("2").Range("I87") 0 Then Worksheets("2").Range("A84:I99").Select And so on You need to set worksheet, context of work! -----Original Message----- 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 Then Range("A52:I67").Select Selection.PrintOut Else If [I87] 0 Then Range("A84:I99").Select Selection.PrintOut Else If [I119] 0 Then Range("A116:I131").Select Selection.PrintOut End If End If End If End Sub Thank you for you help! . |
All times are GMT +1. The time now is 12:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com