PDA

View Full Version : How to know value of margin of the last row on page



majlo
10-11-2009, 03:56 PM
Hi all, thanx in advance if someone can help me. I would like to know how can I find out what is the value of the margin of the bottom line of last row on page. Thing is, I have some table on 1st sheet , and some other on another sheet. I would like to have macro calculate where that table on 1st sheet ends, so that another table on 2nd sheet begins...so I can print them one below another.
Two seperate tables on two different sheets to be printed on one page. First table may vary in rows and rows heigths, so its bottom line is changeable, and second table`s top margin is depending on that..hope is now clearer.
PS am talking about margins in print preview.
what i want is value of margin of first page, where it ends, so i would know what value of top margin to put on page two

majlo
10-11-2009, 04:10 PM
in addition i am showin pcture to help you guys understand me,thanx