CP: Detecting vertical page break

[Marc Antheunis]

hi,
is there anyway to detect a vertical pagebreak that excel generates
this is needed to be able to repeat a 'title' value in a cell right after
the vertical page break

i can't use the page title for it since the title changed every x columns
so what i'm looking for is some kind of formula wich i can repeat in every
cell on the title row that will look for a pagebreak and if so will repeat a
value from a specific cell

tia,
marc
(sorry i've crossposted this)