Monitor specific cells for change

I have this code that works well for the entire column, but, I only need to monitor every other cell in the columns. the cells I want to monitor are:

B10, 12, 14...B96. the columns to be monitored are B,F,J,N,R. the column part is good. I don't want the pop up box to appear when I change B9, B11, B13 etc...

Please Login or Register  to view this content.

Object doesn't support this object or method. run time error '438'

I'm sure I get this error because of placement of the supplied line. I tried it above the "Select Case" block and above the "If Target.Cells(1).Value <> "" Then"

??????

I still get the same error. Here is all of the code associated with this sheet. And I attached the sheet as well.

when cell D10 is filled with a selection from the list, it should pop up a window to ask how many hours. this should not happen for any other non even cell, see previous post.

Please Login or Register  to view this content.

Does it matte that I'm using Excel 2002?