View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Repeating Rows - Exception

Not without setting up two distinct print jobs.

You could do it with VBA but would still be two print jobs.

Ron de Bruin has code for printing headers or cell ranges on selected pages.

http://www.rondebruin.nl/print.htm#not

You could alter to suit.


Gord Dibben MS Excel MVP

On Mon, 20 Apr 2009 13:23:01 -0700, Art
wrote:

Hello,

I have a spreadsheet with several pages and one row that repeats at the top
of each page when printing. Does anyone know how to exclude a page from
having the repeating row from appearing just from that page? Please advise.