Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

In which pagebreak is a particular cell

  Asked By: Karina    Date: Nov 21    Category: MS Office    Views: 4506
  

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

Share: 

 

No Answers Found. Be the First, To Post Answer.

 
Didn't find what you were looking for? Find more on In which pagebreak is a particular cell Or get search suggestion and latest updates.




Tagged: