Ok what im trying to find out is this.

I have a value in column P that if it is 0 then i need to enter 0 in column
E.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200611/1

Sub ifenter()

If Range("P4").Value = 0 Then
Range("E4").Value = 0
End If

End Sub

of course, this doesn't address what you want to di if p4 DOES NOT = 0.
susan


jln via OfficeKB.com wrote:
Ok what im trying to find out is this.

I have a value in column P that if it is 0 then i need to enter 0 in column
E.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200611/1