Hi, hopefully someone can help:
When writing a macro that conditionally formats cells in a pivot, I find that if the formatting isn't the very last thing I do it disappears?
Principally I want to preserve the formatting and add a filter at the end, but keeping the original formatting. Is there a way this can be done?
Many thanks
Dan