Re: $$Excel-Macros$$ Concat & lookup error

2014-08-13 Thread Paul Schreiner
the people you can, As long as ever you can.” - John Wesley - > > From: veeru h >To: excel-macros@googlegroups.com >Sent: Wednesday, August 13, 2014 10:06 AM >Subject: Re: $$Excel-Macros$$ Concat & lookup e

Re: $$Excel-Macros$$ Concat & lookup error

2014-08-13 Thread veeru h
Thank you very much sir On Wed, Aug 13, 2014 at 5:16 PM, Paul Schreiner wrote: > When you "select table array from another file i.e MData Select A&B Column" > You are selecting the entire column, which is defied along with the number > of rows in the file. > One file (in Excel97 Compatibility f

Re: $$Excel-Macros$$ Concat & lookup error

2014-08-13 Thread Paul Schreiner
When you "select table array from another file i.e MData Select A&B Column" You are selecting the entire column, which is defied along with the number of rows in the file. One file (in Excel97 Compatibility format .xls) can only deal with 65000 rows. the other file has over 1,000,000 rows.   In yo