How can I determine where a page break is located?
Posted by Sue J. Stevens on August 19, 2001 10:00 AM
I have a excel file that is used to display financial data and the user provides narrative explanations for each line of data in the row directly below the financial data. I've set up a macro to automatically resize this row to fit the size of the narrative. When the report is printed, I don't want the financial data to get printed on one page while the narrative gets printed on another page. Is there a keep together function in VBA or Excel? Or, how can I determine where a page break is located thru VBA so I can write code to move it?