Copy Paste Special Values Workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Perfect. Thanks!

JE McGimpsey said:
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
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Workbook to Workbook Paste Special 1
Paste Special Values 3
Paste special VB code. 1
Value ( Excel 2007 Version ) 1
Stop Auto Calculation Q 11
Copying Formulas 1
Copying Worksheet to New Workbook 3
Copy value from changing cells without VBA 1

Back
Top