What is the {} symbol used for???????

[Guest]

I had an Excel VBA test the other day where I had a few questions that I had never seen the symbol or heard the term before? Can someone help me out with this one

What are the symbols { } used for????? I have never seen them used in Excel or VBA and I cannot find anything anywhere!!! Please, please, please can someone help!!!!

 

[DNF Karran]

They go around a worksheet function when it has been array entered
excel adds them automatically when you press ctrl+shift+enter afte
entering a formula as opposed to just hitting the enter key.

Dunca

 

[Chip Pearson]

Lee,

In formulas, the {} indicate that the contents are the values of
an array.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


message

I had an Excel VBA test the other day where I had a few

questions that I had never seen the symbol or heard the term
before? Can someone help me out with this one.

What are the symbols { } used for????? I have never seen them

used in Excel or VBA and I cannot find anything anywhere!!!
Please, please, please can someone help!!!!

 

[Norman Harker]

Hi Lee!

They are used to enclose arrays.

Usually you'll see them surround your formula when you enter it as an
array:

Take:
=AVERAGE(C4:C10-B4:B10+(C4:C10<B4:B10))
Entered by pressing and holding down Ctrl + Shift and then pressing
Enter.

In the formula bar the formula will now appear as:
{=AVERAGE(C4:C10-B4:B10+(C4:C10<B4:B10))}

But you don't insert these parentheses manually.

Within formulas you might also have arrays:

Take non-array-entered formula:
=SUMPRODUCT(--(WEEKDAY($A$282:$A$298,1)={2,3,4,5,6}))

The parentheses surrounding 2-6 are typed in as per normal formula
entries.