detecting a vertical page break

  • Thread starter Thread starter Marc Antheunis
  • Start date Start date
M

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
 
Back
Top