How to pass a 2-dim array to a function in the Immediate Window ...

[Juggler_IN]

A 1-dim array is often passed in Immediate Window as, for e.g., fn_sum(Array(1,2,3)) ... how to pass a 2-dim array to fn_sum()?

 

[Domenic]

You can use Excel's notation for an array constant/literal, and pass it to the Evaluate method of the Application before passing it to your function...

? fn_sum(application.evaluate("{1,2,3;4,5,6}"))

Alternatively, you can use the [ ] shortcut for the Evaluate method...

? fn_sum([{1,2,3;4,5,6}])

Note that a comma delineates a column, and a semi-colon delineates a row.

Also, unlike the Array function, the indexing for the 2-dimensional array starts at 1, not 0.

Hope this helps!

 

[Juggler_IN]

@Domenic ; Thanks ... This helps.

 

[Domenic]

You're very welcome, cheers!