detecting a vertical page break
 

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

detecting a vertical page break
 

xlPageBreakAutomatic

See VBA help: PageBreak

Lars Kofod
Denmark