software

In composing a report of data which changes by date, is it possible to set
the header up to include variable date (as opposed to inserting a date time
or file name)? Is it possible to control data printed in a report so that
there are no orphans (data for a list that runs longer than the space
available on the remaining page)?

Thanks for the help

First enter this macro:Sub Macr()
With ActiveSheet.PageSetup
.CenterHeader = Cells(1, 1).Value
End With
End SubPut something in A1 (like the date), run the macro and the header will be
updated.

--
Gary''s Studentquot;BobbJquot; wrote:

gt; In composing a report of data which changes by date, is it possible to set
gt; the header up to include variable date (as opposed to inserting a date time
gt; or file name)? Is it possible to control data printed in a report so that
gt; there are no orphans (data for a list that runs longer than the space
gt; available on the remaining page)?
gt;
gt; Thanks for the help