What do curly brackets /braces {} do in VBA

**Huugin** · 11-17-2012, 01:55 PM

Hi

What do the curly brackets "{}" do in the below code

Please Login or Register  to view this content.

Peace

**shg** · 11-17-2012, 02:01 PM

Nothing -- that's not valid VBA syntax, with or without the curly braces.

**dogberry** · 11-17-2012, 02:02 PM

http://www.grasshopper3d.com/forum/t...-curly-bracket

Hi

Have a look at the above and see if that helps. Not a question I can answer myself.

Chris

**Huugin** · 11-17-2012, 04:20 PM

Thanks for link dogberry, it seems the curly brackets can be used to insert elements into the array at the same time the array is being typecasted.

@shg, i tried running the code, and you're right that excel does not accept it as valid code; but it's kinda weird as I copied it from a page from the Microsoft Developer Network-- http://msdn.microsoft.com/en-us/libr...=vs.80%29.aspx