ndendrinos
Well-known Member
- Joined
- Jan 17, 2003
- Messages
- 1,694
I would like to add a second condition here like this:
If the value of the offset = 0 OR differs from cellA
Example:
A…..B
1…… (is good)
1……1(is no good)
2……1(is good)
If the value of the offset = 0 OR differs from cellA
Example:
A…..B
1…… (is good)
1……1(is no good)
2……1(is good)
Code:
For Each cell In Range("A17:A35")
If cell.Value <> "" And cell.Offset(0, 1).Value = "" Then