#VALUE!

[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

 

[Jeff Boyce]

This newsgroup supports Microsoft Access, the relational database.

Based on your description, you have a question about a spreadsheet.

Try posting to the newsgroup supporting that spreadsheet.

Regards

Jeff Boyce
Microsoft Office/Access MVP