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
This one I was looking to Confirm from you experts. :) that it gets
transposes to *array format *& hence you get 1D array Thankss
On Saturday, December 13, 2014 3:27:26 PM UTC+5:30, Mandeep Baluja wrote:
>
> This Question is related to array before answering please check my file
> and see what
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
hey vabz you're very close to the answer See what you wrote
Arr = Range("A1:A5") Returns Variant/Variant(1 to 5, 1 to 1) ..bcoz array
size is 5x1, but when you transpose this you get only one dimensional array.
This was my question how a two dimensional array (1 to 5, 1 to 1) on
transposing mov
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
arr = Range("A1:a5")
'Watch : - : arr : : Variant/Variant(1 to 5, 1 to 1) :
Module1.ConvertText2Range
arr = Application.Transpose(Range("A1:A5"))
'Watch : - : arr : : Variant/Variant(1 to 5) : Module1.ConvertText2Range
see this for a single range it doesn't showing the columns. but for the
Vabz I have already run your code and Arr =
Application.Transpose(Range("A1:A10"))
has no columns if i use MsgBox UBound(Arr, 2) *error subscript out of
range. This means that there is no column in arr but only a single range
with one dimension.*
On Saturday, December 13, 2014 3:27:26 PM UT
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
Basically Whenever we move a range into an array the array is always
two dimensional and there is no doubt on that .
But if we transpose a range and move it into an array . it is showing
one dimensional array. That means transpose function is doing something
after transposing an range the r
Basically Whenever we move a range into an array the array is always two
dimentional.But if we transpose a range and move it into an array . how
can it be one dimensional arr = Range("A1:A10") [image: Screen
Clipping]
10 matches
Mail list logo
