Small change to code to Locate Numbers

I have posted this question at Mr Excel but they could not help me due to not having an image and my unclear requirements (which I have corrected here).
https://www.mrexcel.com/forum/excel-...e-count-2.html

I was looking for help on adding on some code to find numbers 1 to 20 that have sets of numbers in the adjacent cell.. The code below works.

Please Login or Register  to view this content.

The code searches 3 ranges D3:D10, G12:G18, I1:I10 ((I will need to be able to add additional ranges in the future). There are numbers (ranging from 1 to 20) in each cell. What I require the code to do for a positive result is to check the cells to the adjacent right of each number in the range for set of numbers in them.

So in my sample data cell D4 has number 7 in it but no set of numbers (2-2 or 99-1 etc.) in cell E4 it so that would be a negative result but in cell E5 which has 1 in it and a 1-1 in cell F5 that is a positive result and what needs to be counted and written to cell B2. The other two positive examples are cell G14 and cell I6. All threw would be counted as a positive result and written to cell B2. There will always be a set of numbers somewhere beside the ranges and so always have a positive result. The expected result is 3 in cell B2.

The 3 cell range are formatted as general and the sets of numbers are formatted as text.

That would do it. Thanks so much for all your help.

find numbers.png

Hi

Thanks for your reply. I understand what you're saying but I'm trying to count how many numbers in the cell range have adjacent cell data in them.

Sorry for the delay in getting back to you. Your code works perfectly. I greatly appreciate it. If you have time/interest I have just posted another problem that I think is similar to this code but I’m not sure. You guys are the experts at this stuff. The post is titled” Code to add numbers”.
Thank-you again.

Christine