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.