yes, but this appies to given example only..
+
*I did not do this for you. God is here working through me for you.*
On Mon, Dec 15, 2014 at 5:45 PM, Mandeep Baluja
wrote:
>
> This one I was looking to Confirm from you experts. :) that it gets
> transposes to *array format *& hence you get 1
VBA array stores single dimensional data as shown below:
[image: Inline image 1]
And when you refer to Range(A1:A5), there is 5 rows & 1 column which looks
like this..
[image: Inline image 2]
So when you transpose Range(A1:A5), data stored in it gets transposes to
array format & hence you get 1
Ok, you are not getting me.
Arr = Range("A1:E5")
Arr = Application.Transpose(Range("A1:E5"))
--Above two returns Variant/Variant(1 to 5, 1 to 5)
so even tho you use transpose Range("A1:E5") you get two dimensional
array..because array size is 5x5
Arr = Range("A1:A5") Returns Variant/Variant(1 to
No, it is not so...
Run this & debug, note carefully in local window..
Arr = Range("A1:E5")
Arr = Application.Transpose(Range("A1:E5"))
Arr = Range("A1:A5")
Arr = Application.Transpose(Range("A1:A5"))
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Mon, D
