Hi. This has been very interesting.

I have run the program using a number of spreadsheet. I can see how this would work. It has highlighted a further aspect of the problem. In order to created maintenance free spreadsheets, I use various areas of different worksheets to creat graph titles (in cells) and text below the graphs. There is a problem in that the text needs reformatting in order to make it presentable.

The problem seems to be with the length of the pages. By inserting (or deleting depending on the case), two rows per page in specific areas, the result is perfect.

Hence my thoughts that a button on a spreadsheet, passing the problem to the sheet and the user making the choice as to what action to take.

Michael