Upravit

Sdílet prostřednictvím


XlRangeAutoFormat enumeration (Excel)

Specifies the predefined format when a range is automatically formatted.

Name Value Description
xlRangeAutoFormat3DEffects1 13 3D effects 1.
xlRangeAutoFormat3DEffects2 14 3D 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 PivotTable.
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 PivotTable 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.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.