I'm trying to write event code to test the contents of every cell in a given column after data is entered. Depending on the result, the focus would move to one of two cells in that particular row.
For example, if the column to be tested is col C and I'm entering data into row 3 then the code would be:
Then, if the focus had moved to Range("Z3"), after data is entered in that cell I want to return the focus to Range("D3")
What I need is generic code that tests every cell in column C after data is entered
Help on this would be greatly appreciated