Guest User

Untitled

a guest
Jul 17th, 2018
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.23 KB | None | 0 0
  1. Sub multi()
  2.  
  3. Dim row as Integer: row = 6
  4.  
  5. With Tabelle1
  6.  
  7. While Not IsEmpty(Cells(row,5))
  8.  
  9. If Cells(row,5).Value > 3 Then
  10. Cells(row,5).Value = Cells(row,5).Value * 2
  11. End If
  12.  
  13. row = row + 1
  14.  
  15. Wend
  16.  
  17. End With
  18.  
  19. End Sub
Add Comment
Please, Sign In to add comment