Pivot CellType Property

This property returns the type of cell, in the form of one of the constants in the following enumeration:

Enum XlPivotCellType xlPivotCellValue = 0 xlPivotCellPivotltem = 1 xlPivotCellSubtotal = 2 xlPivotCellGrandTotal = 3 xlPivotCellDataField = 4 xlPivotCellPivotField = 5 xlPivotCellPageFieldltem = 6 xlPivotCellCustomSubtotal = 7 xlPivotCellDataPivotField = 8 xlPivotCellBlankCell = 9 End Enum

Figure 20-41 shows a pivot table and the PivotCellType values (on the right). You can use this to see what types of cells are contained in a pivot table. For instance, cell A4 has PivotCellType 5, indicating that it is a pivot field cell.

Figure 20-41. PivotCell values

a

e

c

e

f

h

i

j

■î

l m \

■: p

1

(w;

s

m

0

0 0 0

0 d

î

0

»

0

0 0 0

5 d

3

9

£

ï 9 =

9 9

4

shots c-

i j-r-s -

l<tt3

1

■i

a

■1

(irend

j

1;

î

i î

1

1 i

5

&oskm

oaiwtnu

■-âit1 trifit

3* n%

j5

uh

1

3

4

û)(t

5 d

=

s.m sj«

¿j6"s

4f9:7

1

1

4

0 d 0

n n

hrçn;hîf

suip ;j i "-epî

3ï; 1 ■1 h>

25.52ft.

yj t

LA

i a1

i

1

4

0 00

0 d

*

s..in ::' sfc-.

j'739

nea?

1îîîî

(50517

1

4

doc

0 d

suo' tils'iatbois

:

i

j

:

0 d 0

0 0

■o

:un ji stffi

ir-i^

w, î-

14^

2msm

i

2

0 & 0

d d

11

lqsam3

3 .in 0( r-.i i!:

îsît*

34.tî%

1

4

o o e

0 0

•1

sum :j satr

133478

'2î5m

;

125*18

50h = ?>

1

1

0 d 0

0 0

hrin;.hie

;_.in 1-3-15

¿- m

î5.6î*

¿f^j

iflij

1

4 u l1 v

0 u

14

s.in at

j6îojj

:tjî2ï

j74111

13s4e51

1

4

0 d

c

0 0

js

.os -j^eles sum ortr3ftta;h«is

95%

icwi

hjojoctt

0 d

0

0 0

is

lc'f-^-jceles am if sahb

îfrb«

337838

^05665

ss'l's^j

156sîs1

î

2

0 0

0

0 0

17

cm-ultiy

g.in ai t-a-m

14 1i<a

I'j ssw

1i0j00%

1

4

0 d

c

0 0

18

fr^n-.h^o

s-in ;j s^es

■8039

sr.:: i

stso1;

68cs8.

319305

1

1

1

0 d

0

0 0

19

v.rn t-iii^

î5 39%

î5 8î%

31%

1i0flo%

1

4

n o

fi>

0 û

jo

s.in sart

176315

135431

icr^e

s96797

1

4

0 d

0

0 0

j'

«w vofiji s-in i-1 rsfisjcsnis

2*

2s.s2%

m.ù1 1

1îo.oo%

1

î

2

d 0

e

0 d

îî

-,fvv ycf*s..m ^^

3544-sî

î5t71î

3555«

im'jo

î

î

i

0 0

fi>

0 d

23

toil sum oi "'irta:! ^ik

a*.am

¿3w.

100j00%

i

3

3

0 0

c

q 0

»

irtjl sun nl sal«

nest*.

r 30001

î

h

d d

0

o n

0 0

Post a comment