I created a macro to pull data from a table in one worksheet, and copy to a seperate worksheet.
For the example that I attached:
-The data in the Acct Number, Call Days, and Aging Since Code columns were pulled from a table in the seperate worksheet.
-The Age Group columns are produced by a macro, filling in each cell with a formula, and based off of the column in front of them.
-Supervisor Response column is left blank.
At this point in the macro, there is a bunch of copied data, and columns A, B, and D are still colored like the table that they were copied from. The rest of the columns are not formatted yet. Now when my macro goes to format them all into one table, the formatting is different between columns. They have different shades, and have different border types. Why is this happening? I want all columns to be formatted identically, so it appears as a uniform table.
Here is the macro for when it formats to a table:
Bookmarks