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!!!!

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

--
Message posted from http://www.ExcelForum.com

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


"Lee Palmer" <lee(remove wrote in
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!!!!

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.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia