Do you mean set the address of the range so that it is adjacent to the
nearest page break? Or just cycle through a series of range names and set
the value of the cell represented by that range if there is a page break
adjacent to the cell?

Keith

"kman" wrote:

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.