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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Top 5 recurring text values with count 2
Conditional Formatting where Matrix intersects 2
conditional sum? 2
Summing Fields 2 4
Index/match across multiple columns? 19
repost: conditional sum? 5
Macro to add Multiple rows in same sheet 1
sum only positive numbers for certain groups 4

Back
Top