Re: $$Excel-Macros$$ Array_concept

2014-12-13 Thread Ashish Kumar
Hi Sam, Long Time Bro. Welcome Back...!! :) Regards Ashish On 13 December 2014 at 18:32, Sam Mathai Chacko wrote: > Mandeep, > > > It's not like that. For that you'll need to understand how Transpose > works. Try this first ;) > > ARR = Application.Transpose(Range("A1:B1")) > > And

Re: $$Excel-Macros$$ Array_concept

2014-12-13 Thread Sam Mathai Chacko
Mandeep, It's not like that. For that you'll need to understand how Transpose works. Try this first ;) ARR = Application.Transpose(Range("A1:B1")) And ARR = Range("A1:B1") Regards, Sam On Sat, Dec 13, 2014 at 3:27 PM, Mandeep Baluja wrote: > > This Question is related to array befor

$$Excel-Macros$$ Array_concept

2014-12-13 Thread Mandeep Baluja
This Question is related to array before answering please check my file and see what I want to Clear it's not a query it's a concept. I am trying to find out Arr = Application.Transpose(Range("A1:A10")) How array is considering this range whether in rows or in columns or whatever. MsgBox