Copy Paste Special Values Workbook
 

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

Copy Paste Special Values 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 ,
PJFry wrote:

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

Copy Paste Special Values 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 ,
PJFry wrote:

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