Expand Minimize

XlRangeAutoFormat Enumeration (Excel)

Specifies the predefined format when a range is automatically formatted.

Version Added: Excel 2007

Name

Value

Description

xlRangeAutoFormat3DEffects1

13

3-D effects 1.

xlRangeAutoFormat3DEffects2

14

3-D effects 2.

xlRangeAutoFormatAccounting1

4

Accounting 1.

xlRangeAutoFormatAccounting2

5

Accounting 2.

xlRangeAutoFormatAccounting3

6

Accounting 3.

xlRangeAutoFormatAccounting4

17

Accounting 4.

xlRangeAutoFormatClassic1

1

Classic 1.

xlRangeAutoFormatClassic2

2

Classic 2.

xlRangeAutoFormatClassic3

3

Classic 3.

xlRangeAutoFormatClassicPivotTable

31

Classic pivot table.

xlRangeAutoFormatColor1

7

Color 1.

xlRangeAutoFormatColor2

8

Color 2.

xlRangeAutoFormatColor3

9

Color 3.

xlRangeAutoFormatList1

10

List 1.

xlRangeAutoFormatList2

11

List 2.

xlRangeAutoFormatList3

12

List 3.

xlRangeAutoFormatLocalFormat1

15

Local Format 1.

xlRangeAutoFormatLocalFormat2

16

Local Format 2.

xlRangeAutoFormatLocalFormat3

19

Local Format 3.

xlRangeAutoFormatLocalFormat4

20

Local Format 4.

xlRangeAutoFormatNone

-4142

No specified format.

xlRangeAutoFormatPTNone

42

No specified pivot table format.

xlRangeAutoFormatReport1

21

Report 1.

xlRangeAutoFormatReport10

30

Report 10.

xlRangeAutoFormatReport2

22

Report 2.

xlRangeAutoFormatReport3

23

Report 3.

xlRangeAutoFormatReport4

24

Report 4.

xlRangeAutoFormatReport5

25

Report 5.

xlRangeAutoFormatReport6

26

Report 6.

xlRangeAutoFormatReport7

27

Report 7.

xlRangeAutoFormatReport8

28

Report 8.

xlRangeAutoFormatReport9

29

Report 9.

xlRangeAutoFormatSimple

-4154

Simple.

xlRangeAutoFormatTable1

32

Table 1.

xlRangeAutoFormatTable10

41

Table 10.

xlRangeAutoFormatTable2

33

Table 2.

xlRangeAutoFormatTable3

34

Table 3.

xlRangeAutoFormatTable4

35

Table 4.

xlRangeAutoFormatTable5

36

Table 5.

xlRangeAutoFormatTable6

37

Table 6.

xlRangeAutoFormatTable7

38

Table 7.

xlRangeAutoFormatTable8

39

Table 8.

xlRangeAutoFormatTable9

40

Table 9.

Show:
© 2014 Microsoft