+ Reply to Thread
Results 1 to 4 of 4

Copy and paste as values, except pivot tables

  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?

    Please Login or Register  to view this content.
    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.

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365 ProPlus
    Posts
    9,371

    Re: Copy and paste as values, except pivot tables

    Maybe this...

    Please Login or Register  to view this content.
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

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

    Re: Copy and paste as values, except pivot tables

    Thanks sktneer, appreciate your reply and help.

    I have 10+ worksheets to copy and paste as values. I wonder if there is any quicker and faster way by slightly adjusting the codes.

    Thanks

    Quote Originally Posted by sktneer View Post
    Maybe this...

    Please Login or Register  to view this content.

  4. #4
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365 ProPlus
    Posts
    9,371

    Re: Copy and paste as values, except pivot tables

    Maybe this...

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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