Stop the Repeating Rows on the last page to print
 

Hi,

I know how to make the same rows print at the top of each page of a
worksheet which prints out - using the "Rows to repeat at top" in the
Page Setup area. What I was wondering is, if there is a way to
prevent the rows repeating on the last page that prints, and 1 step
further, if it was possible to stop the rows printing on the last page
under certain business rules which would be defined in VBA?

Thanks in advance.
Ben Tesoriero.