Results 1 to 4 of 4

Copy and paste as values, except pivot tables

Threaded View

  1. #1
    Registered User
    Join Date
    01-23-2018
    Location
    Germany
    MS-Off Ver
    2010
    Posts
    4

    Copy and paste as values, except pivot tables

    This works perfectly copying all formulas and pasting as values. However, I need a code to not copy pivot tables. Any suggestions?

    
    Sub AllValues()
    
    'Loop all worksheets in workbook
    
    Dim wSh As Worksheet
    For Each wSh In ActiveWorkbook.Worksheets
    
    'Copy
    
    With wSh.UsedRange
    .Copy
    
    'Paste
    
    .PasteSpecial xlPasteValues
    End With
    Next wSh
    
    Application.CutCopyMode = False
    End Sub
    Crosspost Excelguru

    Link supplied by mod: https://www.excelguru.ca/forums/show...T-pivot-tables

    Thanks
    Last edited by AliGW; 12-29-2018 at 08:39 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 06-26-2017, 12:49 AM
  2. Empty values in pivot chart changed to zero after copy/paste
    By krong in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-30-2014, 08:58 PM
  3. [SOLVED] Copy Column in pivot table and paste values
    By marreco in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-26-2014, 09:32 AM
  4. How-to Copy and Paste Values from list into Pivot Table filter
    By MacroNerd in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-05-2013, 06:26 PM
  5. VBA - copy a sheet, setting formulas to values and keeping Pivot tables
    By kaligad in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-27-2013, 09:15 AM
  6. [SOLVED] copy pivot, paste Values and borders
    By jomili in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-06-2010, 05:03 PM
  7. Excel 2007 : Paste Special Values for Pivot Tables
    By PaulTaylor in forum Excel General
    Replies: 16
    Last Post: 08-11-2009, 05:07 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1