M
mireille
Hello !
The problem is that Cells(i,8) is either a date, either an error value (and
shows #VALUE!).
How can I check the error value ???
For i = 2 To 200
If (Cells(i, 8) <> "#VALUE!") Then Date1 = Cells(i, 8)
If (Cells(i, 8) = "#VALUE!") And (Cells(i, 4) = "OPSM") Then Cells(i, 9) =
Date1 - 14
If (Cells(i, 8) = "#VALUE!") And (Cells(i, 4) <> "OPSM") Then Cells(i, 9)
= Date1 - 21
Next i
Thanks for your help
The problem is that Cells(i,8) is either a date, either an error value (and
shows #VALUE!).
How can I check the error value ???
For i = 2 To 200
If (Cells(i, 8) <> "#VALUE!") Then Date1 = Cells(i, 8)
If (Cells(i, 8) = "#VALUE!") And (Cells(i, 4) = "OPSM") Then Cells(i, 9) =
Date1 - 14
If (Cells(i, 8) = "#VALUE!") And (Cells(i, 4) <> "OPSM") Then Cells(i, 9)
= Date1 - 21
Next i
Thanks for your help