Label Range Property

The LabelRange property returns a Range object that represents the label cells for the PivotItem. Figure 20-38 illustrates the results of the code:

ActiveSheet.PivotTables("Sales&Trans").

PivotFields("Store Type"). PivotItems("Company").LabelRange.Select

Figure 20-38. LabelRange for Store Type = Company

A

B

c

D

E

F

G

1

Year

(All)

?

°erlod

n

4

Store City

i-tore Type

Data

1

2

3

4

BOSTON

Corn Deny

Trans

28248

28714

2S67,?

28602

6

■■■

Sale

44673

46927

46256

46223

7

franchise

Trans

13993

13942

13275

132 ID

8

S :le

2181?

■ 17 39

10032

18325

9

LOS ANGELE!

Company

Trans

34588

35938

35692

3500 I

10

Sale

123478

12R564

12S34Ü

135418

11

Franchise

Trans

71533

72947

75619

74302

12

Sale

21:12431

263274

279325

274531

13

NEW YORK

Company

Trans

246 If;

26104

27015

26854

14 '

Sale

78089

85251

87905

88058

15

Franchise

Trüns

53273

54351

5182?

51213

16

Sale

176353

182461

170537

167446

0 0

Post a comment