View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Alan12345 Alan12345 is offline
external usenet poster
 
Posts: 1
Default Printing with ""

I have a chart and it uses a forumla to retrieve data, and if no data is
available it sets the cell to "". My problem is that when I try to print the
worksheet, it prints an extra blank page (because of all the "").

My forumals look something like:

=if(DATA,GET THE DATA,"")

Is there a way to prevent an extra page from being printed without using
Print Area?