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 krishnak...@gmail.com wrote:
That's not true.
MATCH(A,**L6:L27,0) is not
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 krishnak...@gmail.com wrote:
Hi
Replace
Flg =
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
*From:* Brian brianfosterbl...@gmail.com
*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 it is actually text I am
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 Help,
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 exits
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.
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 Boolean
@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
If Not Flg Then
'do something
End If
End Sub
Kris
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
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
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
12 matches
Mail list logo