Kris,
Sorry, you are quite right. I made the mistake of copying the previous
code and replacing the prvious code with the previous codes.
thank you so much for your patience.
On Thu, Mar 22, 2012 at 2:49 PM, Kris wrote:
> That's not true.
>
> MATCH("A",**L6:L27,0) is not equal to MATCH("AA",
That's not true.
MATCH("A",L6:L27,0) is not equal to MATCH("AA",L6:L27,0).
Can you attach the workbook ?
Kris
--
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 Pro
This works just as well as the other code but still has the problem, If
range (L6:L27) has the letters AA in it then it shows A as a match and says
report A is already done
On Wed, Mar 21, 2012 at 4:34 PM, Kris wrote:
> Hi
>
> Replace
>
> Flg = Evaluate("ISNUMBER(LOOKUP(9.**999E+307,SEARCH(D18,
Hi
Replace
Flg = Evaluate("ISNUMBER(LOOKUP(9.999E+307,SEARCH(D18,L6:L27)))")
with
Flg = Evaluate("ISNUMBER(MATCH(D18,L6:L27,0))")
Kris
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Hel
>
> *From:* Brian
> *Sent:* Saturday, March 10, 2012 10:53 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Re: Match text to a list
>
> Thank you Kris, your solution works perfectly. I was just wondering why
> you use "IsNumber" when
isnumber is based on the SEARCH returning same
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Brian
Sent: Saturday, March 10, 2012 10:53 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Match text to a list
Thank you Kris, your solution works
Thank you Kris, your solution works perfectly. I was just wondering why
you use "IsNumber" when it is actually text I am looking for? I mean it
works but I am just curious.
On Saturday, March 10, 2012 11:06:57 AM UTC+2, Brian wrote:
>
> I am using Excel 2007
> In cell D18 I have some text.
>
I didn’t read it COMPLETELY. Still like pure vba better.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Kris
Sent: Saturday, March 10, 2012 8:31 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: Match text to a list
So what ?
On Saturday
2012 4:55 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Re: Match text to a list
>
> Hi
>
> Sub kTest()
>
> Dim Flg As Boolean
>
> Flg = Evaluate("ISNUMBER(LOOKUP(9.999E+307,SEARCH(D18,L6:L27)))")
>
> I
> In cell D18 I have some text.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Kris
Sent: Saturday, March 10, 2012 4:55 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Match text to a list
Hi
Sub kTest()
Dim Flg As Bool
Hi
Sub kTest()
Dim Flg As Boolean
Flg = Evaluate("ISNUMBER(LOOKUP(9.999E+307,SEARCH(D18,L6:L27)))")
If Not Flg Then
'do something
End If
End Sub
Kris
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. P
I am getting an error on
i = Application.WorksheetFunction.Match(Source, target)
On Saturday, March 10, 2012 11:06:57 AM UTC+2, Brian wrote:
> I am using Excel 2007
> In cell D18 I have some text.
> I need the VBA to check if this text appears in the list in Cells L6:L27
> If it does it then exit
12 matches
Mail list logo