+ Reply to Thread
Results 1 to 2 of 2

undo conditional formatting while copying a table to another sheet

  1. #1
    Forum Contributor
    Join Date
    02-27-2020
    Location
    Rotterdam, The Netherlands
    MS-Off Ver
    2013
    Posts
    425

    undo conditional formatting while copying a table to another sheet

    Hi,

    I have created a macro that copies a table from one sheet to another. The problem is that it also copies the conditional formatting from a colomn to the new tabel.
    I really would like to copy the table but without the conditional formatting. Is this possible?

    Any input is much appreciated!

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,623

    Re: undo conditional formatting while copying a table to another sheet

    Do you want to copy just plain data (values) or formulas too? How about non-conditional formatting?

    Basically - instead of
    copy - paste
    sentence you would need
    copy - pastespecial

    you may need to do it more than once for instance first copying valuesandformats then comments etc. See list of available options:
    https://docs.microsoft.com/en-us/off...el.xlpastetype

    BTW. Answer could be more detailed if you'd present at least a part of your code or may be used a hint from a yellow banner near the top of this page
    Best Regards,

    Kaper

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Why am I losing some of the conditional formatting when copying the sheet to a new WB?
    By Gregb11 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-18-2020, 03:49 PM
  2. [SOLVED] Conditional formatting linked to another sheet - constant table row & column
    By Grasshopper Green in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 06-05-2018, 02:05 PM
  3. How Do I Retain Table Formatting (Cell Width) When Copying Sheet Information?
    By kitchenspoon in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-19-2016, 07:09 AM
  4. Unable to Retain Table Formatting (Cell Width) When Copying Sheet Information
    By kitchenspoon in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-18-2016, 08:43 AM
  5. Inserting vs. Copying cell with conditional formatting. Removed sheet reference.
    By phbryan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-05-2016, 11:15 AM
  6. Replies: 9
    Last Post: 05-13-2013, 05:43 AM
  7. Preserve conditional formatting when copying cells from one sheet to another
    By nojamindonut in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-15-2010, 08:44 AM

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