Assumptions: Sheet name = Sheet1, column with date = A, cell with how many
rows deep you want printed = cell G1, total columns worth of data is 6.

First, randomly select some cells and set as print area (this is just to
ensure print area will be defined correctly). Then go to
Insert--Name--Define, highlight the Print_Area, and in the refer to box,
type the following formula:

=OFFSET(Sheet1!$A$1,MATCH(TODAY(),Sheet1!$A:$A,1), 0,Sheet1!$G$1,6)

Hope this helps!
--
John C


"Lawman" wrote:

I want to create a worksheet so that when I click Print, Excel will
automatically print the area defined a top left cell that contains a
particular value in a specified column and the lower right cell is a
manually defined offset from the top left.

In particular, the top left value is to be =TODAY() looked up in a column of
sorted dates, and the offset coordinates will entered in a cell(s) on the
worksheet

Many thanks

Lawman