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. |