If / ElseIf Then Macro to check if a cell (partly) contains a specified text value.

Hi,

Another little Excel roadblock for me today. Can someone help me out? My problem is described in the simple code below. Thanks!

Please Login or Register  to view this content.

Hi
in these circumstance i use

Please Login or Register  to view this content.

this picks up any instance of "ORT" in the cell

Hi Nicky,

Thanks for the reply. How can I best use that in my macro? Or more precisely, how do I change your line to check if the value contains ORT in the prior column. If that is the case I would like the Macro te write "ORT" in the current column(column B) and nut not replace the existing texts in column A.

try

Please Login or Register  to view this content.

Thanks Nicky,

Works like a charm! The eventuel code has now become:

Please Login or Register  to view this content.

Many thanks from sunny Amsterdam!