I have 2 questions that any help on would be much appreciated.

1) Currently when I go to print preview, it says page 1 out of 100000.
Really there is only about 10 pages worth of data and the rest of the pages
are just blank rows. I have a query so that I can't set a print area unless I
want to do it everytime because the number of rows can change by a few from
day to day. I know I could just check the # of pages with data and specify
that each time I print, but I was hoping somebody knew a workaround for this.

2) Some of my cells have lots of text in them. When I print I want this text
to be truncated so that not all of it is visible (or else my # of pages would
be too great). However, I do not want it to truncate right in the middle of
lines/words. I don't want to see 3.5 lines of text in my cell, I would rather
see either 3 lines or 4 lines. Is there a way to make it truncate but not
right through text.

Thanks a million for any help
Chris