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