Specifies the predefined format when a range is automatically formatted.

Version Information
Version Added: Excel

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.