Results 1 to 5 of 5

Thread: Copy and paste into values, EXCEPT pivot tables

  1. #1
    Acolyte thousand's Avatar
    Join Date
    Apr 2017
    Posts
    25
    Articles
    0
    Excel Version
    2010

    Copy and paste into values, EXCEPT pivot tables



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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 AliGW; 2018-12-29 at 01:00 PM. Reason: Code tags added.

  2. #2
    Administrator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,662
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Please wrap your code with code tags. Thanks ( you know how it works)
    Thank you Ken for this secure forum.

  3. #3
    Acolyte thousand's Avatar
    Join Date
    Apr 2017
    Posts
    25
    Articles
    0
    Excel Version
    2010

    Copy and paste as values, except pivot tables


  4. #4
    Acolyte thousand's Avatar
    Join Date
    Apr 2017
    Posts
    25
    Articles
    0
    Excel Version
    2010
    Hi, I can't edit the opening post. Thanks

  5. #5
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,237
    Articles
    0
    Excel Version
    Office 365 Subscription
    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.
    Ali
    Enthusiastic self-taught user of MS Excel!

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •