XlRangeAutoFormat Enumeration
Specifies the predefined format when a range is automatically formatted.
Version Information
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. |