Ways of referring to entire Array row or column

Is there any way to refer to an entire row (or column for that matter) of a 2D Array, or must any reference only be to a single item/position i.e. array(1,1) etc ?

For example, I if I have a 10 row x 10 column array and I want to join all of the values in each row, can I refer in some way to each array row to do that, or must I loop through each item to join them up?

What you want to do is called slicing an array and VBA doesn't support it. Someone may have a clever way to do this but it's not built into the language as a straightforward feature.

I updated your title to say what you are actually asking.

Don't know if I understood things right but if your intent is to output just a single Row only or a single Column only from a multidimensional array, this does that.
Change references as required.

Please Login or Register  to view this content.

Or do you have something like this in mind?

Please Login or Register  to view this content.

The thread is marked as solved but no indication which suggestion was the right one.

Thanks for letting us know that you can live with the solutions.
Good luck. It'll be busy tomorrow.