Advertisement
Guest User

Untitled

a guest
Nov 21st, 2014
151
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.34 KB | None | 0 0
  1. Private Sub Worksheet_Change(ByVal Target As Range)
  2.  
  3. dim x as Integer
  4. x=0
  5.  
  6. If Not Intersect(Target, Range("C50")) Is Nothing Then
  7.  
  8. If Not IsEmpty(Cells(49, 3).Value) Then
  9. If x = 0 Then
  10. Cells(49, 3).Value = Cells(49, 3).Value + 0.8
  11. x = x+1
  12. End If
  13.  
  14. End If
  15.  
  16. End If
  17. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement