Hi,
I have a spreadsheet that gets created via automation from Visual Foxpro. I would like to be able to add the facility to automatically add page breaks before the spreadsheet gets printed.
The spreadsheet itself is always 1 page wide and is printed in landscape mode.
The row data contains a cell which has quite descriptive information in. The cell could contain up-to 20 lines of text. If no proper page breaks are set this information will get cut-off (ie half the info at bottom of page, rest of info appearing at the top of next page) during printing. What I want to be able to do is set page breaks so these rows with lots of text in will always get printed on the following page, rather than being cut-off.
Can someone point me in the write direction please? Any VBA snippets would be much appreciated!
I have a spreadsheet that gets created via automation from Visual Foxpro. I would like to be able to add the facility to automatically add page breaks before the spreadsheet gets printed.
The spreadsheet itself is always 1 page wide and is printed in landscape mode.
The row data contains a cell which has quite descriptive information in. The cell could contain up-to 20 lines of text. If no proper page breaks are set this information will get cut-off (ie half the info at bottom of page, rest of info appearing at the top of next page) during printing. What I want to be able to do is set page breaks so these rows with lots of text in will always get printed on the following page, rather than being cut-off.
Can someone point me in the write direction please? Any VBA snippets would be much appreciated!
