View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Marc Antheunis Marc Antheunis is offline
external usenet poster
 
Posts: 1
Default 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