LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Changes to Plot area color My Own IT dept Charts and Charting in Excel 3 August 28th 08 02:28 AM
how do i change the color of the GUI highlight area? Monkey Excel Discussion (Misc queries) 1 May 31st 07 03:31 AM
Conditional Format of the CHART AREA COLOR Justin Luyt Charts and Charting in Excel 1 August 31st 06 08:56 AM
Data Area of Pivot Table and Pivot Charts Missy Charts and Charting in Excel 2 April 13th 06 12:51 AM
pivot table+put unique data in 'row area'+count of items in 'data area' bubz Excel Programming 0 August 31st 04 04:22 AM


All times are GMT +1. The time now is 11:59 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"