Excel 2010 :: Reference Cell Value Not Formula

Excel 2010. When the result of the formula in Col. E is less than zero, I need to move the row to another sheet, and then delete the row.

I modified another poster's script as follows:

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
' Move rows with negative value in E to Flagged Items sheet
Dim rng As Range
' Set Target Range
Set rng = Target.Parent.Range("E2:E200")

[Code] ........

The script works perfectly if a negative value is manually entered into a cell in Col. E, but not when the result of the formula produces a negative number.

I can't find a way to make the Case Is < 0 act on the resultant value rather than the formula.

Is this possible in the script or is there another way to achieve the desired result?