Thread: Stopping blank cells with formulae in from printing
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
nickname[_2_] nickname[_2_] is offline
external usenet poster
  
Posts: 2
Default Stopping blank cells with formulae in from printing
I have created a new workbook and in cell B1 I have put the formulae
"=IF(ISBLANK(A1),"",44)". I have then used the fill down function to fill it
down to row 65536. When I go to file print preview its going to print 1821
blank pages. How can I stop it from printing cells that show no value but
contain formulae?
Reply With QuoteReply With Quote