Assuming "chart" is just a range of cells on a worksheet, perhaps a Dynamic
Print Range will do the trick.

See Debra Dalgleish's sitr for creating named Dynamic Ranges which ignore
the ""


Gord Dibben MS Excel MVP

On Wed, 23 Jul 2008 10:38:01 -0700, Alan12345
wrote:

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?