I need to identify cells in row Q that contain words "Donor"/"donor" or "Transplant"/"transplant" either in the beginning or in the middle of a sentence. The following line of code looks for an exact match. If there are other words in a cell it doesn't find it. Please alter this line so it allows for other text to be present in a cell
Thank you
Cells(x, 17).Value = "Donor" or Cells(x, 17).Value = "Transplant"</pre>
Thank you
Cells(x, 17).Value = "Donor" or Cells(x, 17).Value = "Transplant"</pre>