I have a named range at the top of a worksheet which resides in a row that
repeats at the top of each page. I would like to dynamically set the value
of this range which is in this case a cell each time there is a page break.