Re: $$Excel-Macros$$ vba code instr - help to understand it

2011-06-26 Thread STDEV(i)
its look like to extrac a* list of unique values *form Range Rng1 CMIIW On Mon, Jun 27, 2011 at 6:24 AM, netuser1110 wrote: > Hi, > > Does anyone can explain me what this loop does and more specificly the > "InStr" function the way it is used below : > > For Each Cel In Rng1 > If Len(

Re: $$Excel-Macros$$ HaPpY BirthdaY - Sir Paul Schreiner

2011-06-26 Thread Venkatesan c
* Dear Paul, ** Happy Birthday Wishes to you * -- *Best Regards,* *Venkat* * * On Mon, Jun 27, 2011 at 8:30 AM, OpenExcel.com <26may.1...@gmail.com> wrote: > Wish you many many Happy Returns of the Day :) Enjoy :) > > HappY BirthdaY :) > > > Best Regards > Ashish Jain > eXceLiTems

$$Excel-Macros$$ Urgent requirement for Reporting Analyst-- Gurgaon Location

2011-06-26 Thread Jaideep Panchal
Hi Group, I have few openings for MIS-Lead in Gurgaon location in a leading BPO company. If you are interested then pls send your resume to me at jai.ca...@gmail.com with your current CTC. Experience required for Job: 3 - 5 years Job Annual Salary: 2.5 - 3.5 Lacs Job location: Gurgaon Skills:

Re: $$Excel-Macros$$ HaPpY BirthdaY - Sir Paul Schreiner

2011-06-26 Thread SANJAY SONI
Dear Paul Sir,   Wish You Many Many Happy Returns of the Day !!   Enjoy the day..! Sanjay From: OpenExcel.com <26may.1...@gmail.com> To: excel-macros@googlegroups.com Sent: Monday, 27 June 2011 8:30 AM Subject: $$Excel-Macros$$ HaPpY BirthdaY - Sir Paul Schreiner Wish you many many Happy Retur

Re: $$Excel-Macros$$ vba code instr - help to understand it

2011-06-26 Thread Vasant
Hi syntax : InStr( [start], string_being_searched, string2, [compare] ) searches for (lowercase value of in cell 'Cel' concatenated with '«') in TmpX On Mon, Jun 27, 2011 at 4:54 AM, netuser1110 wrote: > Hi, > > Does anyone can explain me what this loop does and more specificly the > "In

$$Excel-Macros$$ Macro to copy and paste selected raws.xls

2011-06-26 Thread Atul Patel
Attachment to my request. Attached is a sample file. I need a macro code to copy selected raws (yellow highlighted) from the liquidity tab of a given spreadsheet and paste to other file say 'Book1'. The selection criteria would be based on Column A. I want to copy first working day of each mont

$$Excel-Macros$$ vba code instr - help to understand it

2011-06-26 Thread netuser1110
Hi, Does anyone can explain me what this loop does and more specificly the "InStr" function the way it is used below : For Each Cel In Rng1 If Len(Cel) > 0 Then If InStr(1, TmpX, LCase(Cel) & Chr(171)) = 0 Then TmpX = TmpX & LCase(Cel) & Chr(171) n = n + 1:

$$Excel-Macros$$ Need a help in autopopulation of data

2011-06-26 Thread Anshul
i m comparing 3 cells with one columns with the help of sumif.I just want to autopopulate distinct value from this columns write now I am using array formula for the same but this make it file so heavy and it will take time in calculating cells if you need futher information please let me know wher

Re: $$Excel-Macros$$ Want to excel in excel

2011-06-26 Thread Vasant
welcome On Sun, Jun 26, 2011 at 5:32 PM, Arundatti M wrote: > Allow me to join > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldai

$$Excel-Macros$$ HaPpY BirthdaY - Sir Paul Schreiner

2011-06-26 Thread OpenExcel.com
Wish you many many Happy Returns of the Day :) Enjoy :) HappY BirthdaY :) Best Regards Ashish Jain eXceLiTems -- -- Some important links for excel users: 1. Follow us on TWITTER for tips

$$Excel-Macros$$ Want to excel in excel

2011-06-26 Thread Arundatti M
Allow me to join -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=187131

Re: $$Excel-Macros$$ Macro to expand tree node

2011-06-26 Thread Simran Singh
any update on this experts Simran On Fri, Jun 24, 2011 at 9:30 AM, Simran Singh wrote: > Hi all, > > I need a macro to expand the tree node on internet and select the name > after expanding the each node. I am attaching a screen shot of the of the > tree node how it is look like. > > Regard

Re: $$Excel-Macros$$ Leave tracker help required

2011-06-26 Thread maulik desai
Hi All, Awaitnig your reply Kindly revert with the solution. On Sun, Jun 19, 2011 at 5:42 PM, maulik desai wrote: > Hi All, > > I am having 1 Excel sheet which contains 3 sheets > In sheet1 main database i have to update in every month for Leave > calculation > In Sheet2 I have to find out the