View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
darkblue darkblue is offline
external usenet poster
 
Posts: 35
Default 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.