|
-
Nov 11th, 2005, 02:19 PM
#8
Thread Starter
Junior Member
Re: Update cell in xcel
This is the exact code:
Private Sub Worksheet_Change(ByVal Target As Range)
If (Target.Address = "M169") Or (Target.Address = "$D$173") Or(Target.Address = "$D$175") Then
If Range("M169").Value = 1 And Range("D173").Value <= 7 Then
If (Range("D175").Value > 0) And (Range("D175").Value <= 10) Then
Range("I175").Value = (0.3)
Range("I179").Value = (-1#)
Range("I183").Value = (-1.8)
Range("I191").Value = (-2.8)
Range("I195").Value = "N/A"
Range("I199").Value = (-1.7)
Range("I203").Value = (-1.7)
Range("I207").Value = (-2.8)
End If
End If
End If
End Sub
Thanks. I appreciate.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|