Copy and paste into values, EXCEPT pivot tables

thousand

New member
Joined
Apr 2, 2017
Messages
30
Reaction score
0
Points
0
Excel Version(s)
2010
Hi there

Does anyone now how this macro can copy and paste values except pivot tables.

Code:
Sub AllValues()
Dim wSh As Worksheet
For Each wSh In ActiveWorkbook.Worksheets
With wSh.UsedRange
.Copy
.PasteSpecial xlPasteValues
End With
Next wSh
    
Application.CutCopyMode = False
End Sub


Many thanks!
 
Last edited by a moderator:
Please wrap your code with code tags. Thanks ( you know how it works)
 
Hi, I can't edit the opening post. Thanks
 
OK - I have done it for you this time. In future, you must do this yourself as soon as you add code to a post. Thanks.
 
Back
Top