Can someone tell me what is wrong with this code?
Does it have something to do with 2 and statements?
Sub cDOW_State()
Dim cDOW As Range
For Each cDOW In ActiveSheet.Range("H2904:H" & Cells(Rows.Count, "H").End(xlUp).Row)
If cDOW.Value.IsNumber And cDOW.Offset(0, 3).Value = "Urgent" And _
cDOW.Offset(-3, -9).Value = "M" Then cDOW.Select
Next cDOW
End Sub
Thank you for your help. I'm trying to learn what I can and when stuff like this happens it drives me nuts... and I can't stop staring at it....and pressing F8!
Bookmarks