Repeating rows not wanted

  • Thread starter Thread starter Opal
  • Start date Start date
O

Opal

I am running Excel 2003 and not sure why this
is happening. I have a 2 page report and there
is a header plus I have flagged two rows to
repeat at top (12 & 13). But when I print the
report I get all rows from 1 to 13 repeating at
the top? Has anyone come across this?
Does anyone have any advice?
 
You cannot do this.

Rows to repeat at top must start from the top and be contiguous.


Gord Dibben MS Excel MVP
 
It seems to work for me, but maybe not in the way the OP wants it. If I number
the cells in column A with the row number, then go to File / Page Setup / Sheet
/ Rows to repeat at top: and enter $12:$13, my printed pages show the following:

Page 1 - number 1 through 52
Page 2 - number 12 & 13 and then 53 through 102
Page 3 - number 12 & 13 and then 103 through 152
Page 4 - number 12 & 13 and then 153 through 202
 
It used to repeat just 12 and 13 and now all of a sudden
and I don't know why, it is repeating 1 - 13.
 
Same in 2003 and 2007

I misspoke.

Rows 12 and 13 won't appear as repeating on first page but will on each
successive page.

Right as always...............NOT! <g>


Gord
 
??

Yes, they used to repeat and suddenly not...not sure why
or how this happened, but I can't get these rows to repeat
anymore.
 
Opal said:
??

Yes, they used to repeat and suddenly not...not sure why
or how this happened, but I can't get these rows to repeat
anymore.
Click to expand...

Make sure you have only this one worksheet selected, then go to File / Page
Setup / Sheet / Rows to repeat at top: and enter $12:$13. When you print (or
Print Preview), what is the result?
 
Opal said:
the result is

Page 1

Rows 1 - 21

Page 2

Rows 1 - 9, 22-29
Click to expand...


Makes no sense. If you want, and if the workbook is less than 1mb, email it to
me at schwandtg at aol dot com and I'll take a look at it.
 
Thanks, I wish I could, but the information in it
is proprietary. The only thing we were thinking
was maybe our IS Dept has failed to install
a Microsoft update..... :-(
 
I came up with a work around.

Utilizing the following placed in ThisWorkbook
from Ron DeBruin

Private Sub Workbook_BeforePrint(Cancel As Boolean)
If ActiveSheet.Name = "Sheet 1" Then
Cancel = True
Application.EnableEvents = False
Application.ScreenUpdating = False
With ActiveSheet
.Rows("22:23").EntireRow.Hidden = False
.PrintOut
.Rows("22:23").EntireRow.Hidden = True
End With
Application.EnableEvents = True
Application.ScreenUpdating = True
End If
End Sub

I copied rows 12:13 to 22:23 where I need them
and used the above code. It works. The only issue
I will have is if the rows increase on page one of the
report I may have to adjust where I put 22:23.
 
Back
Top