Can 1 row of multi-dimen array, be passed as its own array?

[Lephramla]

Hello all. I would like to know if VBA allows the passing in a procedure call, of 1 row of a multi-dimen array, which is then treated as a 1-dimen array in the procedure that is called. In all my tests, my belief is no it's not possible, but then again I'm also not sure if my syntax has been correct for declaring this array in the params of the called procedure, or for how I'm passing the 1 row in the parentheses of the procedure call, or for the data type in the called procedure. Since I'm uncertain of these things because of how at times the runtime and compile error messages are cryptic, I figured hey it can't hurt to ask.

2 procedures below, the first loads up a 2-dimen array with just something random I thought of while I was typing this message. Then the 2nd procedure is called with only 1 row of this 2-dimen array. My reason for being so curious about this is because I have a circumstance of wanting to act on only 1 row at a time of multiple 2-dimen arrays.

Or maybe the only way to do such a method is to pass each row's members individually in the procedure call itself?

Thank you and have an awesome day
=========================================================

Please Login or Register  to view this content.

...........or what about using a For Each loop on the items in just a specific row of the 1st dimension of the array....

Please Login or Register  to view this content.

[protonLeah]

Please Login or Register  to view this content.

[Lephramla]

Thank you THANK YOU Ben! A huge monstrous "thank you"!! A member function or whatever of WorksheetFunction...nope, wouldn't have thought of exploring that group, but then I'm still kinda' new to the language & nuances of VBA. And the way you illustrate the use of this one row inside the called subroutine is fantasimo, thank you mucho again. This is double-mucho awesome to learn, and besides I'm now thinking it's time I take a look-see at all the WorksheetFunction members/whatever to see what other gems might just be there. The only other I've learned about so far is "Transpose". Would've read this and replied sooner but my time is pretty busy with various things.

Thank you again Ben, and have an awesome day :-)
Kirby

[protonLeah]

You're welcome.