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
The code you supply works perfectly except for one issue.
I am checking a column to see if I have run a report before and therefore
the check for the match. The problem is I have one report marked AA and
another marked A. If I have run the report AA before then when I run the
report A, the code
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 pe
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
So what ?
On Saturday, 10 March 2012 19:10:11 UTC+5:30, Don Guillett wrote:
>
> > 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
> 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
F
