I think I'd apply Data|Filter|autofilter to that range.

Then right before I print filter on the date column to show just the dates in
which I'm interested. Then print those visible rows and then
data|Filter|showall to see everything after the print.

GLT wrote:

Hi,

I have a sheet that is printed out on a daily basis which is basically a
list of tasks to do.

Some of the tasks only run on certain days and not others, some tasks are
done everyday.

Basically what I would like to do is when the worksheet is open on screen,
it displays all rows for editing etc, but when I print the worksheet out, it
only prints rows relevant for that day and hides the rows not relevant.

Any help would be greatly appreciated.

Thanks.

--

Dave Peterson