Hi,

I have a Nested Loop that is taking a value from one workbook, which has a scpecific cell color....

So once that Outer Loop value is determined from the first book, It's going to scan inside a pivot table (Just down the intersecting column) to find that value from Book 1.
Once inside the pivot where in the nested part of the loop.

When running the Macro, I see that the interior cell color changes but reverts back to the normal format (inside the pivot) once the code has fully ran.
Here is a look at the code....



Please Login or Register  to view this content.