VBA search and compare strings

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Excel spreasheet and in worksheet_1 I have a word in each cell from E2 to H51. On worksheet_2 I have a column of cells each with two words in them. I am trying to write a VBA macro that says; if a word from range E2:H26 and a word from range E27:H51 is in a cell in worsheet_2 then write a "No" in the next column in workshhet_2 but on the same row, else write a "Yes".

Many thanks for any help.

Stuart
 
Hi Stuart
why not use a worksheet formula. e.g. in B1 on sheet 2 enter
=IF(COUNTIF('sheet1'!$E$2:$H$51,"*" & A1 & "*"),"No","Yes")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
Printing a Page Automatically When All Cells are Filled 7
conditional programming 1
VBA code adds unwanted characters 2
Macro maximum range lengths 2
Copy non blank rows only 2
Help with a complicated For ... Each ... Next statement. 1
Excel VBA 1

Back
Top