Guest User

Untitled

a guest
Jul 17th, 2018
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.33 KB | None | 0 0
  1. Sub multi()
  2. Dim intZeile As Integer
  3. Const Faktor = 2
  4.  
  5. With Tabelle1
  6.  
  7. intZeile = 6
  8. Do Until .Cells(intZeile, 5).Value = ""
  9.   If .Cells(intZeile, 5).Value >= 4 Then
  10.  
  11. Dim tmp as Integer
  12. tmp = intZeile * 2
  13.  
  14. .Cells(intZeile, 6).Value = tmp
  15.  
  16. End If
  17.  intZeile = intZeile + 1
  18. Loop
  19.  
  20. End With
  21.  
  22. End Sub
Add Comment
Please, Sign In to add comment