Jack,

It will work as long as you don't change the selection in between copying and pasting.

HTH,
Bernie
MS Excel MVP


"Jack Brackson" wrote in message
...
Is there a way to convert all the formulas in a spreadsheet to values.

I tried copy-paste special-values but there are merged cells and that does
not work.

TIA.