See http://www.codeforexcelandoutlook.co...repeat-at-top/

ActiveSheet.PageSetup.PrintTitleRows = "$1:$1"

would repeat row one at the top of each printed page.

--JP

On Oct 5, 9:12*am, Subodh wrote:
On Sep 23, 12:02*am, Gord Dibben <gorddibbATshawDOTca wrote:


Do you mean when printing you want to set "rows to repeat at top" ?

You cannot do this with grouped sheets.

You would require VBA macro to perform that operation.

Gord Dibben *MS Excel MVP


* *Has any one got VBA code for this