Copy Paste

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.

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" <[email protected]> wrote in message
news:[email protected]...
> 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.
>
>
>