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.