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

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 <08231B2F-2043-470F-93BB-(E-Mail Removed)>,
PJFry <(E-Mail Removed)> wrote:

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

Perfect. Thanks!

"JE McGimpsey" wrote:

> 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 <08231B2F-2043-470F-93BB-(E-Mail Removed)>,
> PJFry <(E-Mail Removed)> wrote:
>
> > What is the easiest way to copy and paste special values an entire workbook?
>