Re: $$Excel-Macros$$ Run time error 9 subscript out of range - lotto Query

2014-06-09 Thread Vaibhav Joshi
Here you are declaring Dim tbl(1 To ntbl, 1 To 2) As Long when vale of m drops belwo 1 you will get error 9 change lines to.. Dim tbl(0 To ntbl, 1 To 2) As Long can comment whether this will work without your sample data. Cheers!! On Tue, Jun 10, 2014 at 10:41 AM, Vaibhav Joshi wrote: > He

$$Excel-Macros$$ Run time error 9 subscript out of range - lotto Query

2014-06-09 Thread Vaibhav Joshi
Hey Will Welcome! You need to start new thread as per forum rule so that you get attention & proper resolution of your solution.. Did this code worked proper;y previously ? Cheers!! On Tue, Jun 10, 2014 at 1:24 AM, Will Sob wrote: > Dear Expert, > > Please look at this code what is wrong wi

$$Excel-Macros$$ Urgent required Quality Analyst - Fremont, CA

2014-06-09 Thread Gary .
*Please respond to gurjant.si...@damcosoft.com * *Position: Quality Analyst Location: Fremont, CADuration: 6+ Months* *Only Local Profiles Required * JD: Responsibilities - In detail • Work with other teams members to understand customer requirements and come up with meaningful solutions. • W

Re: $$Excel-Macros$$ run time error 9 subscript out of range

2014-06-09 Thread Will Sob
Dear Expert, Please look at this code what is wrong with it I'm not an expert in VBA but would need some of your knowledge in this matter I want to put together a formula that takes say a 6/49 lotto and point out say I want to find the most occurring triples, it finds them and show how many times

Re: $$Excel-Macros$$ run time error 9 subscript out of range

2014-06-09 Thread Vaibhav Joshi
Hi change line to LastRow = Workbooks("Quantum R-Creator.xlsm").Worksheets("Dump").Range("E1048576").End(xlUp).Row + 1 If you include workbook name then you need to also add file extension too. Cheers!! On Mon, Jun 9, 2014 at 11:07 PM, Secret Shot wrote: > Dear Expert, > > I am working on a

$$Excel-Macros$$ Urgent required IOS Developer - Fremont, CA

2014-06-09 Thread Gary .
*Please respond to gurjant.si...@damcosoft.com * *Position: IOS DeveloperLocation: Fremont, CADuration: 6+ Months* JD: Strong iOS Application development Experience. Candidate should have experience in building consumer facing apps. Experience with Performance tunining of the apps. Ability to

Re: $$Excel-Macros$$ Help for Macro

2014-06-09 Thread Vaibhav Joshi
ok.. I will try to send you by tonight.. Cheers!! On Mon, Jun 9, 2014 at 12:08 PM, Shrinivas Shevde wrote: > Dear Vaibhav > Thanks for reply. > As I mentioned earlier today I have 10 rows and I run the macro. I will > get output. > Tomorrow I will add more 12 rows and if I run the macro I wil

Re: $$Excel-Macros$$ Similar Items

2014-06-09 Thread Vaibhav Joshi
Cheers!! On Mon, Jun 9, 2014 at 5:37 PM, Virkar,Nilesh wrote: > Thanks Buddy J > > > > Cheers > > > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Vaibhav Joshi > *Sent:* Monday, June 09, 2014 5:20 PM > > *To:* excel-macros@googlegroups

RE: $$Excel-Macros$$ Similar Items

2014-06-09 Thread Virkar,Nilesh
Thanks Buddy ☺ Cheers From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Vaibhav Joshi Sent: Monday, June 09, 2014 5:20 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Similar Items Hi PFA Hit the blue button & duplicate items will

Re: $$Excel-Macros$$ Similar Items

2014-06-09 Thread Ashish Kumar
Hi Nilesh, Apply this formula in Cell C2 =+IF(COUNTIF($A$2:$A$48962,B2)=0,"0","Similar") Regards Ashish On 9 June 2014 10:15, Virkar,Nilesh wrote: > Hi, > > > > I want the similar item in separate sheet OR in separate Colum. > > > > Regards > > Nilesh Virkar > > > > *From:* excel-macros@goo