Easiest? One way (assuming no array formulae):

Dim ws As Worksheet

For Each ws In ActiveWorkbook.Worksheets
With ws.UsedRange
.Value = .Value
End With
Next ws


In article ,
PJFry wrote:

What is the easiest way to copy and paste special values an entire workbook?