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?
Bookmarks