If cell contain any of x text, then

[sdoppke]

Hi everyone can some one help me with a mod to my macro i need to have the macro start with checking sheet1 A1 for any text matching sheet2 a2. better desctription would be sheet1 A1 will contain july-11 and sheet 2 will contain july. If they match, then it will delpoy the "then" portion (A message box).


Thanks everyone in advance

sd

 

[Ruddles]

It sometimes takes a few exchanges, especially when we're not both ooking at the same worksheet.

Thanks for the feedback.