color pivot area
My pivot table opens with different number of rows and columns each
time when i refresh it.
How can I color it with correct rows and columns by vba ?
Something like:
clean previous color on the sheet
refresh pivot
color again
Any help ? Thank you very much.
|