I have a table below which place for total sum and signatures are left.
I don't want that the signatures are left on the last table, so I
decrease in page setup scale of the page. I wonder if there is a
function which can help to determine in which particular page is a cell.

To ilustrate let's pretend that, sum cell is D1000 and last signature
is D1005. I want to determine if they are on the same HPageBreak. I
will call SumPageBreak, the page break on which is sum cell. And I will
call LastPageBreak, the page break of cell D1005.



while not sumpagebreak = lastpagebreak
a=ActiveSheet.PageSetup.Zoom
ActiveSheet.PageSetup.Zoom=a-1