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

2014-06-12 Thread Vaibhav Joshi
I m still not clear, can you explain 1st line of Input and how you derived result. On Thu, Jun 12, 2014 at 1:34 AM, Will Sob will00...@gmail.com wrote: Hi Joshi, this is my data 7 9 18 24 39 40 4 18 26 32 36 40 45 21 10 31 35 40 41 44 46 2 5 9 28 29 48 36 10 19 20 33 45 46 25 15 26

Re: $$Excel-Macros$$ Repeat Header Rows in prints for specific sheets

2014-06-12 Thread Rohan Young
hi, i am talking about the Repeat Top Rows not header or footer thanks On Wed, Jun 11, 2014 at 10:42 PM, Vaibhav Joshi v...@vabs.in wrote: Check this link.: http://www.mrexcel.com/forum/excel-questions/456534-excel-visual-basic-applications-change-header-each-page.html Cheers On Jun

$$Excel-Macros$$ Date Format Query

2014-06-12 Thread Pravin Gunjal
Hi, I wanted to convert the dates in this format *DD.MM.* Now it is not in system's date format ( MM/DD/ ) and it is displayed as DD/MM/ or as D/M/. Kindly help. Regards Pravin Gunjal. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

Re: $$Excel-Macros$$ Repeat Header Rows in prints for specific sheets

2014-06-12 Thread Vaibhav Joshi
If there is sheets 1 to 10..You want to repeat 1st row of sheet 1 on all pages of sheet 1,2,3 etc.. it it correct?? On Thu, Jun 12, 2014 at 2:33 PM, Rohan Young rohan.j...@gmail.com wrote: hi, i am talking about the Repeat Top Rows not header or footer thanks On Wed, Jun 11, 2014 at

Re: $$Excel-Macros$$ Repeat Header Rows in prints for specific sheets

2014-06-12 Thread Rohan Young
no bro, i want Repeat Top row should come in print on every individual sheet's first 6 pages. from page 7 i dont need Repeat Top Row in prints it should come in print without Repeat Top Rows in remaining pages. Same is for rest of the sheets. Thanks On Thu, Jun 12, 2014 at 3:27 PM, Vaibhav

Re: $$Excel-Macros$$ Date Format Query

2014-06-12 Thread Pramod Singh
Hi Pravin Gunjal, PFA Hope This will fine for you.. Warm Regards Pramod VBA Developer On Thu, Jun 12, 2014 at 3:12 PM, Pravin Gunjal isk1...@gmail.com wrote: Hi, I wanted to convert the dates in this format *DD.MM.* Now it is not in system's date format ( MM/DD/ ) and

Re: $$Excel-Macros$$ Repeat Header Rows in prints for specific sheets

2014-06-12 Thread Vaibhav Joshi
PFA Cheers!! .*show(Time)* On Thu, Jun 12, 2014 at 4:02 PM, Rohan Young rohan.j...@gmail.com wrote: no bro, i want Repeat Top row should come in print on every individual sheet's first 6 pages. from page 7 i dont need Repeat Top Row in prints it should come in print without Repeat Top

Re: $$Excel-Macros$$ Repeat Header Rows in prints for specific sheets

2014-06-12 Thread Rohan Young
thanks a lot bro On Thu, Jun 12, 2014 at 4:33 PM, Vaibhav Joshi v...@vabs.in wrote: PFA Cheers!! .*show(Time)* On Thu, Jun 12, 2014 at 4:02 PM, Rohan Young rohan.j...@gmail.com wrote: no bro, i want Repeat Top row should come in print on every individual sheet's first 6 pages.

Re: $$Excel-Macros$$ Repeat Header Rows in prints for specific sheets

2014-06-12 Thread Rohan Young
please also solve my query of folders of mails logbook regds On Thu, Jun 12, 2014 at 5:05 PM, Rohan Young rohan.j...@gmail.com wrote: thanks a lot bro On Thu, Jun 12, 2014 at 4:33 PM, Vaibhav Joshi v...@vabs.in wrote: PFA Cheers!! .*show(Time)* On Thu, Jun 12, 2014 at 4:02 PM,

Re: $$Excel-Macros$$ Repeat Header Rows in prints for specific sheets

2014-06-12 Thread Vaibhav Joshi
Hi simply delete that line.. On Thu, Jun 12, 2014 at 5:06 PM, Rohan Young rohan.j...@gmail.com wrote: please also solve my query of folders of mails logbook regds On Thu, Jun 12, 2014 at 5:05 PM, Rohan Young rohan.j...@gmail.com wrote: thanks a lot bro On Thu, Jun 12, 2014 at 4:33

Re: $$Excel-Macros$$ Excel Add-in (that enables Auto-complete)

2014-06-12 Thread Waqar Ahmed
Hello everybody, I have a problem that I can't increase the list range , I can't find value (Range name List) Please help. Regards On Thursday, April 25, 2013 12:54:17 PM UTC+5:30, Abhi wrote: Please see the attached. First sheet (List) has the list of items wherein the VBA would search to

Re: $$Excel-Macros$$ Excel Add-in (that enables Auto-complete)

2014-06-12 Thread Abhishek Jain
Its a name range. See the range under Name Manager in the Formulas tab (Excel 2007). HTH/Abhishek On Thu, Jun 12, 2014 at 6:29 PM, Waqar Ahmed asif.waqar1...@gmail.com wrote: Hello everybody, I have a problem that I can't increase the list range , I can't find value (Range name List)

Re: $$Excel-Macros$$ help: someone help me crack the password for these 2 macro files?

2014-06-12 Thread Paul Schreiner
You really shouldn't expect much help from this group in this case, since it violates Forum Rule #3:   There are LOTS of places on Google that you can find people who willingly allow someone to steal someone else's work.   (5,340,000 hits on Break Excel password)    I know, you aren't trying to

Re: $$Excel-Macros$$ Re: How to pause the Excel VBA macro at certain point and then start again

2014-06-12 Thread Paul Schreiner
Did you TRY what I described? or even Ravinder's suggestion of Browser.busy or Browser.ReadyState?   There are two things: You SAID that Application.Wait does not work. When used properly, Application.Wait DOES work, it just might not help in your case.   The second thing is the infinite loop.

$$Excel-Macros$$ Urgent required Java Front End/UI Developer - Santa Clara, CA

2014-06-12 Thread Gary .
Please respond to gurjant.si...@damcosoft.com *Position: Java Front End/UI Developer/ LeadLocation: Santa Clara, CADuration: 6-12 Months, Long term* Primary Skills: Front End / JavaScript / HTML / CSS / AngularJS Description: Lead front end Developer to deliver high level and cutting edge

Re: $$Excel-Macros$$ Re: How to pause the Excel VBA macro at certain point and then start again

2014-06-12 Thread Sukanta Datta
I did not mean to say Application.Wait does not work. It works but it does not work for my code at that point because I have noticed that file generation stops until the timer is over. The problem I am having that when I run without the break mode the line where I assign wb4 never set and it

Re: $$Excel-Macros$$ Re: How to pause the Excel VBA macro at certain point and then start again

2014-06-12 Thread Paul Schreiner
File Generation stops until the timer is over...   Is this application generating the file? or is it being created from another  process?    The code is a little cumbersome (to me).   Here's what I observe:   -This code is contained in a workbook (name not specified)  

$$Excel-Macros$$ Urgent required OIM Developer / Lead - Chicago, IL

2014-06-12 Thread Gary .
*Please respond to gurjant.si...@damcosoft.com gurjant.si...@damcosoft.comPosition: OIM Developer / Lead Location: Chicago, ILJob Type: Long Term* Joining: Immediate (Experience: 5 + years) Please check the following while sharing a profile: 1.We are looking for specifically Oracle Identity

$$Excel-Macros$$ Urgent required Oracle Identity Manager Developer / Lead - Chicago, IL

2014-06-12 Thread Gary .
*Please respond to gurjant.si...@damcosoft.com gurjant.si...@damcosoft.comPosition: OIM Developer / Lead Location: Chicago, IL Job Type: Long Term* Joining: Immediate (Experience: 5 + years) Please check the following while sharing a profile: 1.We are looking for specifically Oracle Identity

Re: $$Excel-Macros$$ Re: How to pause the Excel VBA macro at certain point and then start again

2014-06-12 Thread Sukanta Datta
The .csv file is created by an Internet application which I call from macro. It is working correctly and generating the file as I wanted. I post the part of the code which is not working when I run it on regular mode but it works when it is in break mode and I execute it line by line. This code

Re: $$Excel-Macros$$ Need quick help with excel - election results

2014-06-12 Thread Victor Momoh
Attached is the workbook with formulas that can help you achieve this On Fri, Jun 13, 2014 at 1:06 AM, Djordje Padejski djordje.padej...@gmail.com wrote: hello everyone, This should be easy, but I'm stuck with Excel. Have election results in 4 columns. A Candidate name, B Location, C

Re: $$Excel-Macros$$ Need quick help with excel - election results

2014-06-12 Thread Djordje Padejski
thanks, I really appreciate -- Best, Djordje Padejski investigative journalist entrepreneur cell: + 1 650 888 3846 email: dpadej...@cironline.org, padej...@stanford.edu skype: djordje.padejski www.padejski.net FOIAMachine.org founder - hosted by Center for Investigative Reporting, Berkeley

Re: $$Excel-Macros$$ Re: Can We creat Auto Mailer In Excel.

2014-06-12 Thread Vaibhav Joshi
Hi How do you want to trigger email creation?? From where to pick email id? On Mon, Jun 9, 2014 at 9:41 PM, khagesh khera khagesh.kh...@gmail.com wrote: Dear Team, Thanks for helping me but we are not getting any great help from the above. Please find enclosed the email copy which we