$$Excel-Macros$$ Re: Type Mismatch error

2015-11-17 Thread Mandeep Baluja
> > Hi Shrini, > Generally this error occurs in case of Type mismatch, There are various possible reasons,lets try to figure this out I can consider you are doing an operation after this if condition you check with that cell and suddenly it encounter a Text entry where it cannot do the operat

Re: $$Excel-Macros$$ Re: Type Mismatch error.

2012-11-19 Thread अनिल नारायण गवली
Dear Prince, Pl share a sample workbook with us. Regards, Gawli Anil On Tue, Nov 20, 2012 at 8:42 AM, Prince wrote: > Hi Paul, > > These numbers of columns in my array.and i wanted to assign this columns > after transposing or after making it rows to a range. > > regards > Prince > > > On M

$$Excel-Macros$$ Re: Type Mismatch error.

2012-11-19 Thread Prince
Hi Paul, These numbers of columns in my array.and i wanted to assign this columns after transposing or after making it rows to a range. regards Prince On Monday, November 19, 2012 10:20:40 PM UTC+5:30, Paul Schreiner wrote: > > How are you getting 155,206 columns? > > In Excel 2010, there ca

$$Excel-Macros$$ Re: Type Mismatch error.

2012-11-19 Thread Paul Schreiner
How are you getting 155,206 columns? In Excel 2010, there can be only 16,384 columns (and 1,048,576 rows) So, there must be an issue with where you're coming up with that number. Paul On Monday, November 19, 2012 12:47:53 AM UTC-5, Prince wrote: > Hi Group, > > i am getting type mismatch er