Are you using the word 'chart' in the Excel manner, or do you mean a range
of cells?
If the latter you will need to manually adjust the PrintArea with File |
Print Area
,unless you are ready for some complex VBA
best wishes

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Alan12345" wrote in message
...
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?