Hi I have a spreadsheet with a table that works fine but I have added to the end of it a text box containing terms and conditions. the issue I have is that when the table expands it mof coursemoves the text box down a line at a time which is fine. What I want to acheive is to 1. Set th print area via vba to the row after the where the textbox finishes and two prevent the text boxt being split over two pages. If the text box was always the last page that would be great. Many thanks