move between pages in excel

[mn12]

Hi,
I create report in excel.I display more than 50 rows on the report,and so excel creare automatically 2 pages.
I want the same title to be shown on the two pages.
How can I "catch" the event of move between pages?
I have tried like this:
If rows = 50 Then '(excel create new pages after 50 rows)
Range("A5&quot.Select
ActiveCell.FormulaR1C1 = "aaaa"
End If
but...probably it's not good enough.

do you have any ideas for my problem?

thanks for your time!

 

[combo]

If you need only to repeat the same title - you can repeat a row in sheet's page setup:
[tt]Worksheets("TheReport&quot.PageSetup.PrintTitleRows = "$1:$1"[/tt]

Alternatively the header can serve as title (20 is the font size):
[tt]Worksheets("TheReport&quot.PageSetup..LeftHeader = "&20The Report"[/tt]

combo

 

[mn12]

thank you, but I can't use it because I must know the position(coloumn and row)where the title is.
(the title includes some titles:
aaaa bbb ccc ddd eee--> this is my whole title.
each one of them is a title of a coloumn in my report.
and so I must know exactly where it is(col and row).

 

[mn12]

thank you combo,it works!
see my previous massage as cancalled!