$$Excel-Macros$$ Match text to a list

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 the sub otherwise it must do something else. Can anyone help with this code. -- FORUM RULES (986+ members already BANNED for violation) 1) Use

Re: $$Excel-Macros$$ Match text to a list

Hi Brian, You can include the following code in your macro:- Sub chk() Source = Range(d18) target = Range(L6:l27) i = Application.WorksheetFunction.Match(Source, target) If i = 0 Then 'continued.. paste your code here End If End Sub Regards, DILIPandey On Sat, Mar 10, 2012 at 2:36 PM,

Re: $$Excel-Macros$$ Match text to a list

Subject: $$Excel-Macros$$ Match text to a list 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 the sub otherwise it must do something else. Can anyone help with this code. -- FORUM RULES (986+ members