compile error method or data member not found will not run as a sub

I am back needing help again. I have written an error check sub routine to check for blank required cells before the row status is completed. I am getting a compile error, “Method or Data Member not Found” and I don’t understand the Microsoft help file. Could someone help me and explain what I am missing please? The Sign_In sheet is where the data is entered and column “K” is the final status for the row. It will display the fill of the cell green and the ending code will be shown in the cell. For the ending code “ATR” in column “K”, cells in columns “I”, “J”, “L” can’t be blank or empty in that row. The cells missing the data will fill red and the “K” column will turn yellow to indicate a problem in that row. The code worked fine until I changed it to a sub routine. All help is greatly appreciated!

I have uploaded a sample workbook.

Here is my code:

Please Login or Register  to view this content.

Thanks again for any help received.

Thanks for your help.
I thought that the

Please Login or Register  to view this content.

was defining the SheetName?

So what did that define?

The Srn was the target row from the WorkSheet ("Sign_In") I forgot that I could not carry that over into the Subroutine.
This is to be run only when the target Row column "K" is closed by the entry of "ATR" (This does the error check for the required data entry.

I do have others that will run with other codes but I should be able to do those once I can get this running.

Am I to do something with

Please Login or Register  to view this content.

or is this just an information line?
I am still new at this and trying to learn as I go, but sometimes I just can't seem to understand what is happening to write my code. Please bear with me as a NOOB. I won't be able to try it on the actual WorkSheet until tomorrow when I get back to work!
Thanks Again for the help.

I was told to use subs for redundant code to speed up programing. I can send to the error check sub using this (in yellow) on the Sign_In sheet.

Please Login or Register  to view this content.

After the error check and corrections are done then the green code is to be run to close the status of that row.
I have other status code groups that will have common error checks so I figured that I can get this one working then adapt the others from this one.
I used your code but couldn't get it to work. This is what I am trying to get the code to do for the ATR code: 1. check column cell "I" if it is empty then change the fill color to red, clear contents of "K", send error message for cell "I", turn cell "K" to yellow, exit sub if error is found to make the corrections, 2. the same for column cell "J" and "L", If no errors are found Turn "K" green with "ATR" in the cell then to return and execute the array in green.
I tried to have the code exit on error (Exit Sub) but it only runs once then stops. I have attached another updated Workbook showing what I am trying to do.
Here is the updated code:

Please Login or Register  to view this content.

Thanks for your help.

Sorry about picking the wrong colors for highlight. Here is what was in yellow:

Please Login or Register  to view this content.

And this is what was in green:

Please Login or Register  to view this content.

Thanks for the help.

I just noticed in the code you did for me you are starting the rows at row 4 and the workbook actually starts at row #5. I will change it and try the code again.

I still can't get it to run, it just stops with no error.

It now gives me a compile error Srn not defined. I put this code into the sub routine module. and called it from sheet1("Sign_In"). Could you please explain what is happening in the code?

bakerman2 thanks for all your help. I think I have found another way to do this.

Sorry I forgot to do that. It's done now. Thanks again.