Formulas as Values
 

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.

Try:

For Each c In Cells.SpecialCells(xlCellTypeFormulas)
c.Value = c.Value
Next

--
Damon Longworth

Don't miss out on the 2005 Excel User Conference
Sept 16th and 17th
Stockyards Hotel - Ft. Worth, Texas
www.ExcelUserConference.com


"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.

I am sorry, I do not understand your answer. Is that a macro?

Is there another way using the toolbar?

Thank you.


"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.

You could use a normal paste value if you remove merged cells. This is one
of the reasons I do not use merged cells. Use Center Across Columns and you
should be able to get the same visual effect.

--
Damon Longworth

Don't miss out on the 2005 Excel User Conference
Sept 16th and 17th
Stockyards Hotel - Ft. Worth, Texas
www.ExcelUserConference.com


"Jack Brackson" wrote in message
...
I am sorry, I do not understand your answer. Is that a macro?

Is there another way using the toolbar?

Thank you.


"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.