Bad example.
So lets say I want column 6 to be "To do"
I try to make from:
If Not Intersect(Target, Columns(15)) Is Nothing Then
To:
If Not Intersect(Target, Columns(15)) Is Nothing And Intersect(Target, Columns(6)).Value = "To Do" Then
That didn't work, so I tried:
If Not Intersect(Target, Columns(15)) Is Nothing And Range("F:F").Value = "To Do" Then
I thought I could figure this addition out for myself.. But I think I am way off here.
Could you be so very kind of telling me how this one must be? Last question, I swear![]()
Bookmarks