Back to Forms in Excel VBA archive index

Back to archive home

Any help with:- Why the curly brackets {} around a formula?

Thanks

Thanks

Check out our Excel Resources | ||||

Those brackets show up when you enter a formula by hitting CONTROL+SHIFT+ENTER at the same time, instead of just enter as in

=MIN(IF(A1:A10,A1:A10))

which, when entered by hitting CONTROL+SHIFT+ENTER at the same time, will appear on the Formula Bar as

{=MIN(IF(A1:A10,A1:A10))}

The only time you enter these curly brackets yourself is when you feed some function a constant array as argument as in

=VLOOKUP(A1,{"a",1;"b",2;"c",3},2,0)

where {"a",1;"b",2;"c",3} represent a 2-column table.

Curly brackets are thus associated with the so-called array formulas and constant arrays.

See the Excel help topic for...

"Values that do not change in array formulas"

This archive is from the original message board at www.MrExcel.com.

All contents © 1998-2004 MrExcel.com.

Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.

Microsoft Excel is a registered trademark of the Microsoft Corporation.

MrExcel is a registered trademark of Tickling Keys, Inc.

All contents © 1998-2004 MrExcel.com.

Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.

Microsoft Excel is a registered trademark of the Microsoft Corporation.

MrExcel is a registered trademark of Tickling Keys, Inc.