Just to add:
You just need to be aware that if you do File=Page Setup (no other action
necessary), it removes your formula for that page and replaces it with a
hard coded range. so avoid doing page setup.

--
Regards,
Tom Ogilvy


"Debra Dalgleish" wrote in message
...
You can create a dynamic range named Print_Area, as described he

http://www.contextures.com/xlNames01.html

In the Offset formula, you can count the cells that contain text. For
example, if column A will always have an entry if the row is used:

=OFFSET(Sheet1!$A$1,0,0,COUNTIF(Sheet1!$A$1:$A$250 ,"<"),33)

tankerman wrote:
My spreadsheet has 250 rows and A thru AG in columns, all cells are
bordered. All of the columns are used if a row is used. My sheet has 15%
more rows than our highest use this year so that I am sure our office
does not run short of rows (my workbook has 12 of these sheets because we
track the info monthly and forward the sheets as filled out to other
personel). My question is how do I print the sheets (only one month is
printed at a time) to print only the rows that has been filled out, all
of the sheet rows are continuous, we have no unused rows except for the
ones left at the bottom that are unused. when ever I print the sheets it
always prints a few extra pages from the bottom that are just the
gridding. I don't want to have to delete all of the unused row before I
print the sheet.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html