Transposing rows/columns in an array
Depending on the version of excel that you're using and the number of elements
in your array, you could use application.transpose:
Dim myArr1 As Variant
Dim myArr2 As Variant
myArr1 = ActiveSheet.Range("a1:d2").Value
myArr2 = Application.Transpose(myArr1)
Bob wrote:
Is it possible to transpose a given "row" or "column" within a 2-dimensional
array (similar to the way it can be done in a worksheet)? If so, can someone
kindly point me to VBA code snipets that demonstrate this capability.
Thanks in advance for any guidance.
--
Dave Peterson
|