found where to add it, thanks
but it gives me this error msg:

The name that you entered is not valid,

Reasongs for this can include;
- the name does not begin with a letter or an underscore
- the name contains a space or other invalid characters
- the name conflicts with an Excel built-in name or the name of another
object in the work book



"Glenn" wrote:

Need Help on axis problem in a chart wrote:
Hi,
I would like to set auto print area to an worksheet.
I have fixed width (number of columns), but length (number of rows with
values) changes, anywhere from 50 to 500.
Is there any way I can make the print area that will change according to the
length of the data on the table? Any help will be appreatiated.

This page has a very long table that imports numbers from other page
(sheet), I only want to print till numbers appear on the table, and dont
want to print the empty cells (blank portion) of the table at the bottom of
the page. If excel auto selects the print area, then it prints the whole
table.


HERE IS HOW MY PAGE LOOKS

I have 2 sheets, on the first sheet I do the calculations.

second sheet is the one I need to print, which gets the results from the
first sheet. Results shows up in a very long table (500
rows), but only fills up till my data goes, (It varies from 50, 500).
I want to print only till my data (cells with values) skipping the empty
(zeros)
portion of my table.

table would look like this with table (or borders) in it. Dont wana print
zeros at the end. want the excel to select the print area itself.

2 12 323 212 23 32
5 32 321 312 45 23
5 34 542 345 66 64
3 55 343 432 52 51
2 12 323 212 23 32
5 32 321 312 45 23
5 34 542 345 66 64
3 55 343 432 52 51
2 12 323 212 23 32
5 32 321 312 45 23
5 34 542 345 66 64
3 55 343 432 52 51
0 00 000 000 00 00
0 00 000 000 00 00
0 00 000 000 00 00
0 00 000 000 00 00
0 00 000 000 00 00
0 00 000 000 00 00


Try this for Print_Area definition in the Define Name dialog:

=INDIRECT("A1:F"&COUNTIF(Sheet1!A:A,"0"))