Hi DB,

But that copies the cell numerical values into the new sheet without
transferring the formulae that created them.<

Err No. That pastes the formulae or if there is no formula in a cell it
pastes the value

(The formula bar contains the number in the cell, not the formula that led
to it).<

Errr No again. The formula bar displays the true value of a cell whether it
is a formula or a number or text or whatever and that is the value that is
copied, not the 'display' that is shown in the actual cell.

Regards
Martin