Hello, I think I'm losing it in my old age. I'm having trouble creating the correct VBA syntax for this issue:
If A2 contains (" - ")
AND
O2 IS BLANK
THEN
O2 = 0
End if
If that isn't clear, what I'm trying to do is if A2 contains a space-dash-space AND Cell O2 is blank,
then replace Cell O2 with a Zero. Then I will need to run that down the column.
Something in the back of my mind is telling me that the Excel formula to do this and the vba code to do this are not the same.
Thanks for the help!
P.S. I forgot to mention that if the value in O2 is some other number, I want to retain that number. Details, details, details.....
Bookmarks