Thread: Print range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.setup
Lawman Lawman is offline
external usenet poster
 
Posts: 19
Default Print range

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