>Perhaps I am misinterpreting the question, but lemme give it College try:
>If I want to paste setcions with formating and other stuff, when building the select range I include top border area (the letters), which copies the whole columns down, including formating and formulae.
>
>Usually I have a special area reserved for input values, thus giving me options to compare different input values by comparing the sheets - either on the same page or for more series-letter printing (for example weekly bills for a client) I create a lineinfo sheet where each bills variable data are kept on a single line (misusing that sheet as a dbf/table) plus the "printout" page with the standard text (a report in vfp) with a single cell to specify which line in the lineinfo sheet shall be used for printout. Can be enhanced by other cell specifying name of the sheet to use and so on - you might remember the hint on next Excel function to look up ;-))
>
>The lineinfo-setup is also nice to compare long range interest cost, for instance those offered with interest rates either climbing or falling at certain time points. All basic calc, but hard to guesstimate the exact effects of each financial offer.

If I copy the entire section using the Link option, this should work. It does work on my home PC with a test spreadsheet. However, tomorrow, I will do additional tests with the main spreadsheet. I believe it might be related to certain destinations on sheet #2, where it might work on certain places while pasting the same content elsewhere wouldn't. I will proceed by elimination until I find the factor(s) which could be of influence.

Thanks