Hi,
I am interested in creating a macro that will adjust the page breaks in a worksheet. The worksheet consists of hundreds of tables of cross tabulation data. What I would like to do is for the macro to move down the worksheet and determine if the current page break exists in the middle of the table and if so then to move the page break above the table title.
I was thinking this is possible by examining the font such that the tables contents are regular font where as the title font is Bold.
Any help would be greatly appreciated.
I am interested in creating a macro that will adjust the page breaks in a worksheet. The worksheet consists of hundreds of tables of cross tabulation data. What I would like to do is for the macro to move down the worksheet and determine if the current page break exists in the middle of the table and if so then to move the page break above the table title.
I was thinking this is possible by examining the font such that the tables contents are regular font where as the title font is Bold.
Any help would be greatly appreciated.
