date:20110626

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(Cel) > 0 Then
> If InStr(1, TmpX, LCase(Cel) & Chr(171)) = 0 Then
>TmpX = TmpX & LCase(Cel) & Chr(171)
>n = n + 1: Rng2(n, nCol + 2) = Cel.Value
> End If
>  End If
>   Next Cel
>
> Thanks
>
>

-- 
--
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=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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 
>
> --
>
> --
> 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=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



*
*
*
*

-- 
--
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=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$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:
Should have experience in VBA-- Visual Basic Application
Good Excel/ Access database knowledge


Incase interested, please revert with your updated resume as word attachment 
with answers to following queries -

Current Salary
Expected Salary
Notice Period
Current Location
Any Bond with the current organization


Imp Note:- Our company does not provide transportation/Cabs to Noida and 
Ghaziabad.


Thanks,
Jaideep Panchal
# 9971503994

-- 
--
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=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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 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 tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Best Regards, 

-- 
--
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=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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
> "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: Rng2(n, nCol + 2) = Cel.Value
> End If
>  End If
>   Next Cel
>
> Thanks
>
> --
>
> --
> 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=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Regards

Vasant

-- 
--
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=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$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 month. the 
day should not be either saturday, sunday or holidays. (you can have 
list of holidays on other tab approx 10 days in a given calendar year) 

Per my understanidng this task can be done other way also, copy entire 
spread sheet to Book1 and delete unwanted raws ( means raws not 
matching above criteria) 

Much wiill be appreciated if some one help me this. 

Thanks, 

Atul 



 
Atul Patel
905 785 8324(H)
647 898 4074(C)
atul_pate...@yahoo.com
atul_danga...@rediffmail.com

Good to know you !

-- 
--
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=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Macro to copy and paste selected raws.xls
Description: MS-Excel spreadsheet

$$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: Rng2(n, nCol + 2) = Cel.Value
 End If
  End If
   Next Cel

Thanks

-- 
--
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=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$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 where i enclosed my sheet.Please help as in
validation if someone select TMP (is a channel name) then there city
will show.if someone select another channel then there branchname will
show.Please call me if you need further calirification in this my no.
9711325104

-- 
--
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=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Regards

Vasant

-- 
--
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=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$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 tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$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=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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.
>
> Regards,
> Simran Singh
>
>
>
>
>  --
>
> --
> 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=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
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=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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 total leaves taken in that month with
> dates of "IL & "NCNS" Staus from Sheet 1 (details given in attached sheet)
> In sheet3 i have to update the candidates details as per his leave dates
> (format & details given in attached sheet)
> Request you to kindly provide the solution with the help of formulas &
> macro
>
> For more details kindly find the attached file.
>
> --
> Thanks & Regards,
> Maulik Desai
> 9967363926
>
> --
>
> --
> 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=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Thanks & Regards,
Maulik Desai
9967363926

-- 
--
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=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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

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

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

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

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

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

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

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

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

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

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

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

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

13 matches

Site Navigation

Mail list logo

Footer information