+ Reply to Thread
Results 1 to 1 of 1

Format Data as Table - Row Colors Don't Match

  1. #1
    Forum Contributor
    Join Date
    09-06-2012
    Location
    New York
    MS-Off Ver
    Excel 2007
    Posts
    225

    Exclamation Format Data as Table - Row Colors Don't Match

    This might get confusing, but I am going to try and explain my situation/problem as best as possible.

    *Note:All of the following actions are completed through macros in VBA.

    1. I have a base table in "Sheet1" that is filtered down (obviously formatted as a table)
    2. Certain columns are copied over to "Sheet2", which was previously a blank worksheet
    a. This will fill columns A:D in "Sheet2"
    b. This data in "Sheet2" now holds the color format of the table, but doesn't appear to be a table
    3. In columns E:F of "Sheet2" I have formulas calculating a result, using A:D as the source
    4. "Sheet2" is then sorted using column D as the key

    Problem: When I try to format "Sheet2" as a table, it only formats the colors in the columns with formulas (E:F). So now the lines for E:F are colored every other line (this is good), but the colors for A:D are randomly distributed based on the result of the sorting.

    How do I write a macro to include columns A:F when formatting a table, and have each row be 100% the same color?
    Last edited by Gard5096; 01-16-2013 at 01:22 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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