注意:故意留了1~2处错误,一看便知
'放到模块里
Sub 公式转为值()
Dim rng As Range, c As Range
Dim Sht As Worksheet
For Each Sht In Worksheets
With Sht
Set rng = acticesheet.Range("A1").CurrentRegion
For Each c In rng.Cells
If c.HasFormula Then
c.Value = c.Value
End If
Next
End With
Debug.Print Sht.Name
Next
End Sub