Hi, i programming a prototype application using Excel 2007, VBA and a
pivottable:
Here a more simple example:

2006 2007
Q.1 Q.2 Q.3 Q.4 Sum Q.1 Q.2 Q.3 Q.4 Sum

Rep1 12 13 12 14 51 13 13 11 14 51
Rep2 13 12 12 13 50 14 12 13 11 50
Rep3 13 13 14 14 54 13 13 11 11 48

What I want to do now is, when I mark the sum 51 (by clicking a button) that
all its summands ( 12 13 12 14 ) shall be markt too. All the
marked cells get a blue background. For visible cells it works with
GetPivotData(). But when the quarters are collapst it does not work.

Has anybody an idea?