write column vector of 2D array into 1 D array

**twd000** · 06-22-2010, 03:42 PM

I have a 2-D array dimensioned as

Please Login or Register  to view this content.

and filled with values

I want to assign the column of entries into a 1D array which is dimensioned as

Please Login or Register  to view this content.

I want to do this in a single statement, without using a loop

If I were writing in <real> language like MATLAB, I would just write

Please Login or Register  to view this content.

is there an equivalent in VBA?

**mikerickson** · 06-22-2010, 03:48 PM

If BC_time were dimmed as a Variant, you could use

Please Login or Register  to view this content.

**twd000** · 06-22-2010, 05:03 PM

interesting solution - works like a charm

any idea why Excel would require Variant Dim? I thought the whole point of Option Explicit was to encourage you to declare specific data types?

**shg** · 06-22-2010, 05:20 PM

Because the Transpose function returns a Variant array, which can only be assigned to a Variant. It has nothing to do with Option Explicit.

**twd000** · 06-22-2010, 05:36 PM

then my next question is "why would Transpose, which should simply re-organize array entries, change their data type?" Assuming the user intended the input array to be type Double or whatever, why would the code force an output type of Variant?

**shg** · 06-22-2010, 05:47 PM

Just the facts on the ground, ma'am.

**twd000** · 06-22-2010, 05:52 PM

definitely <interesting> learning the quirks of each programming language

and maybe dangerous to ask "why?" LOL

**StephenR** · 06-22-2010, 05:56 PM

I could tell you, but then shg would have to kill you. And then me.

**shg** · 06-22-2010, 06:01 PM

I imagine it's related to its heritage as a worksheet function, and for the fact that the implementation would be more complex to discern the variable type and return a like type.

Even so, I accept it for Transpose, which could obviously return variable results. I'm less tolerant that it's true for matrix functions, which could only every return numbers (or infinities, or NaN's).