Macro code to convert formula cells into values for all tabs

Question

Hi,

I have a large file of 450 MB with 15 to 20 tabs.

Each tabs is a table link to a data page.

Is there any Macro code that could convert all the formula cells into values keeping all the formatting in the shortest possible time ?

Thank you in advance.

Low

Answer 1

Hi Hans,

Many thanks.

You macro codes work very well.

Low

Answer 2

Here is such a macro:

Sub Formulas2Values()

    Dim wsh As Worksheet

    For Each wsh In Worksheets

        With wsh.UsedRange

            .Value = .Value

        End With

    Next wsh

End Sub