VBA formating for Pivot Table Rows

DMowery · May 9th, 2002, 01:52 PM

Hi All, Hope you can help.

I am writing a macro to call on and manipulate a previously created Pivot Table. The Pivot table has rows called "Plants" each row contains 8 data fields.

I need code that would select EVERY OTHER row (xlDataAndLabels) and format the background grey for readability purposes.

Any Suggestions??

btw: I just found this site and the comments and help are fantastic. Kudos!

Mark W. · May 9th, 2002, 01:58 PM

Have you considered applying the Format | AutoFormat... menu command's "List1" Table Format with only its "Patterns" Option checked?

DMowery · May 9th, 2002, 02:06 PM

Hi Mark,

The problem is the "pivot table row" contains eight "excel rows" of data. The Auto format List1 menu command Zebra stripes the "excel rows" within the "Pivot table row". I need all eight data row alternately shaded and non-shaded.

Any clue??

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 9th, 2002, 01:52 PM	#1
DMowery New Member Join Date: May 2002 Posts: 3	Hi All, Hope you can help. I am writing a macro to call on and manipulate a previously created Pivot Table. The Pivot table has rows called "Plants" each row contains 8 data fields. I need code that would select EVERY OTHER row (xlDataAndLabels) and format the background grey for readability purposes. Any Suggestions?? btw: I just found this site and the comments and help are fantastic. Kudos!

May 9th, 2002, 01:58 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Have you considered applying the Format \| AutoFormat... menu command's "List1" Table Format with only its "Patterns" Option checked?

May 9th, 2002, 02:06 PM	#3
DMowery New Member Join Date: May 2002 Posts: 3	Hi Mark, The problem is the "pivot table row" contains eight "excel rows" of data. The Auto format List1 menu command Zebra stripes the "excel rows" within the "Pivot table row". I need all eight data row alternately shaded and non-shaded. Any clue??