$$Excel-Macros$$ Re: Array_concept

2014-12-14 Thread Mandeep Baluja
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

$$Excel-Macros$$ Re: Array_concept

2014-12-14 Thread Mandeep Baluja
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]