Formulas as Values

J

Jack Brackson

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

Damon Longworth

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
 
J

Jack Brackson

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

Is there another way using the toolbar?

Thank you.
 
D

Damon Longworth

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Paste Special Values 2
Continue Excel to New Uear 9
Pasting formulas 4
copy formulas 1
Copy and Past Values AND Formatting AND Text 1
COPY PASTE VALUES ONLY FROM/ON VISIBLE CELLS 6
Special Pasting a work book with many sheets and formulas 2
Use Find and Replace in Excel 2

Top