Macro to search a range with multiple combined values

Hi All,

I’m back again looking for help in how to set up the following formula code.
I need to count the number of times in col K (K5:K105) any of the following is entered:
"AV", "BT", "RLCCC", "RLCMO", "RLFW", "RLHCC", "RLHMO", "RPCCC", "RPCMO", "RPHCC", "RPHMO", "TA" And matches one of 8 values listed in col AD rows 5 thru 12. I am thinking that part of the code would use a case or array but am not sure on how to set it up. I have the entire code listed if someone can figure out why my code is giving unstable count results.

I had this code listed below but it does not give accurate count seems to give counts from 3 to 6 for one actual entry.

Please Login or Register  to view this content.

Thank you for your help. Well now I am really confused about what is happening. When I put your suggested code into beginning and end on the first entry into the first column everything stops, and no error code is given. The code was working except for the erroneous calculations for what I originally stated. Can you give me any guidance on what may be happening please? Your help is appreciated.

When I try to run it with the first code you listed above it just goes into never-never land, no functions run. I can enter data but it will not run any of the code. It also doesn't give any errors. If I don't have it turned on it will run but gives me bad numbers for the ATR count. It gives different values with every entry, sometime it gives 3 then next time it may be 5, etc. I tried to put a message box between every calculation in the code but it does the same thing and jumps some steps and then stops at different steps. I don't know where to go from here. Thanks again for your help.

I have attached the workbook with sample data.I have labeled what each section of code should do when working properly. Sheets also have sample data that should be placed on them. Thanks again for your help.

Hi all,
I am just checking in to see if anyone has any instruction for me on how to check for errors in my code. The code is included in the workbook. I see the workbook has been viewed 4 times. I do appreciate all help received.