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.
Many thanks!
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: