For Each cell In Range("A10:C200")

If cell.Value2 0 Then

cell.Value2 = cell.Value2
End If
Next cell

--

HTH

Bob

"Michael Lanier" wrote in message
...
I need a macro that will convert a cell's formula to reflect its
formula result only based on the following:

Range is A10:C200
Only when formula's result 0
Execute upon closing the file

Thanks for any help you can provide.

Michael