|
VBA .Transpose(.Transpose
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.
|