Re: $$Excel-Macros$$ Search domain in list and shows related names having the domain

2012-05-30 Thread ANIRUT KOSAYAMAS
2012/5/29, Mangesh Dayne : > Hi Friends, > > Please help me on above query. > > Please . > > > With regards, > > Mangesh > > On Mon, May 28, 2012 at 7:25 PM, Mangesh Dayne > wrote: > >> Hi All, >> >> Please help me on below query. >> >> With regards, >> >> Mangesh >> >> >> On Mon, May 28, 2012 at 5

Re: $$Excel-Macros$$ Search domain in list and shows related names having the domain

2012-05-28 Thread Mangesh Dayne
Hi All, Please help me on below query. With regards, Mangesh On Mon, May 28, 2012 at 5:12 PM, Mangesh Dayne wrote: > HI Noorain, > > Thanks for your reply. > However, I didn't get about the red highlighted code. > I have attached snapshot about what I need. Please find it and help me. > > Let

Re: $$Excel-Macros$$ Search domain in list and shows related names having the domain

2012-05-25 Thread NOORAIN ANSARI
Thanks Mangesh... On Fri, May 25, 2012 at 11:04 PM, Mangesh Dayne wrote: > Simply Awesome !!! > > > On Fri, May 25, 2012 at 8:27 PM, NOORAIN ANSARI > wrote: > >> Dear Mangesh, >> >> Please try it... >> >> *Sub search_domain() >> Dim rng As Range >> Dim rw As Long >> >> Dim sh As Worksheet >> Set

Re: $$Excel-Macros$$ Search domain in list and shows related names having the domain

2012-05-25 Thread NOORAIN ANSARI
Dear Mangesh, Please try it..and see attached sheet.. Sub search_domainname() Dim rng As Range Dim sh As Worksheet Set sh = ThisWorkbook.Sheets(1) For Each rng In sh.Range("H3:H8") If Right(rng, Len(rng) - InStr(1, rng, "@")) = Range("B1") Then MsgBox "Found in Cell" & vbCrLf & rng.Address Exit S

$$Excel-Macros$$ Search domain in list and shows related names having the domain

2012-05-25 Thread Mangesh Dayne
Hi All, Please help me on attached sheet. Thanks lot. with regards, Mangesh -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get