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?

Printing with ""
 

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?

Printing with ""
 

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?

Printing with ""
 

And the URL is http://www.contextures.on.ca/xlNames01.html#Dynamic


Gord

On Wed, 23 Jul 2008 14:00:43 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

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?

Printing with ""
 

On Jul 23, 4:00 pm, Gord Dibben <gorddibbATshawDOTca wrote:
Assuming "chart" is just a range of cells on a worksheet, perhaps a Dynamic
Print Range will do the trick.
How do you make it a print area? Just name it Print_Area?

Printing with ""
 

That would do.

InsertNameDefine will have a Print_Area name.

Just change the "Refers to:" range to the dynamic range formula constructed
from the example at Debra's site


Gord

On Wed, 23 Jul 2008 14:52:12 -0700 (PDT), Spiky
wrote:

On Jul 23, 4:00 pm, Gord Dibben <gorddibbATshawDOTca wrote:
Assuming "chart" is just a range of cells on a worksheet, perhaps a Dynamic
Print Range will do the trick.
How do you make it a print area? Just name it Print_Area?