Print condition ??

  • Thread starter Thread starter sch
  • Start date Start date
S

sch

Is it possible to print a page only if cell A7 contains the test "Apple
or "Banana" AND not print if blank.
What would the formula be?
Thank yo
 
Formulas cannot trigger or block a print. You might try a macro:

If Range("A7").Value <> "" Then ActiveSheet.Printout
 
Back
Top