If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.
I have been looking at various VBA code snippets for something I am trying to do.
I am taking a user-defined range and then passing it to a function which will apply a calculation to all the values in that range (say n ^ 2).
What I see in the snippets is often code that looks like this:
y = .Transpose(.Transpose(y))
Where y is the data range passed to the calculation function.
.Transpose would convert the columnar range to a row array (yes?). But why yet another .Transpose?
My only guess is that this takes a range of data (passed to this calculation function) to make it an array of data with the same dimensionality as the original.
Is that correct? What does .Transpose have to do with making ranges into arrays in VBA?
Thank you for your help.
Transposing twice converts the data from a 2D array (the uniform result in a variant receiving data from a multi-cell range) to a 1D array if the range is a row or column vector.
__________________
Entia non sunt multiplicanda sine necessitate.
Linear Mode
