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 Sub


Put something in A1 (like the date), run the macro and the header will be
updated.

--
Gary''s Student


"BobbJ" wrote:

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