View Single Post
  #3   Report Post  
Old April 16th 19, 08:10 PM posted to microsoft.public.excel.programming
[email protected] jmslab@xs4all.nl is offline
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2009
Posts: 55
Default Loop for text check in three colums and set a text code based onthis in another column

Thanks!.

The thing thats goes wrong now is that the text in the mentioned columns isn't only the letters I wrote. Those letters are a part of the text within that specific cell.
So the text in li,co+13 could be "Blabla AAA blabla"
The text in li,co+22 could be "BBB Bla bla"
The text in li,co+23 could be "Bla CCC"

The macro has to check if the mentioned text is a part of the whole text in the cell. If in all three columns that specific text is found then...... it results in a code.

regards (and thanks!), Johan