bdouglas1011
New Member
- Joined
- Jul 28, 2014
- Messages
- 38
I have code that looks for a cell to be blank and if so then it applies another value.
Problem is I have people in the field that will put n/a or N/A in the cell which screws it all up. How can I add the N/A or n/a to be recognized as blank so the then is applied correctly?
If Range("C4") = "" Then
Problem is I have people in the field that will put n/a or N/A in the cell which screws it all up. How can I add the N/A or n/a to be recognized as blank so the then is applied correctly?
If Range("C4") = "" Then