Advertisement
Guest User

Untitled

a guest
May 24th, 2017
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1.  Sub Przycisk2_Kliknięcie()
  2.     Dim i, k, aaa, bbb As Integer
  3.     Dim Aopt As Double
  4.     aaa = 1
  5.     Aopt = 120
  6.     For i = 1 To 530
  7.         Arkusz1.Cells(17, 16) = Arkusz3.Cells(3 + i, 13)
  8.         If (Arkusz1.Cells(17, 21) < Aopt) And (Arkusz1.Cells(90, 9)) <= 1 Then
  9.             Arkusz4.Cells(aaa, 4) = Arkusz1.Cells(17, 16)
  10.             aaa = aaa + 1
  11.             Arkusz1.Cells(17, 16) = Arkusz4.Cells(1, 4)
  12.         End If
  13.     Next
  14.     bbb = 1
  15.     For i = 1 To 530
  16.         Arkusz1.Cells(17, 16) = Arkusz3.Cells(3 + i, 13)
  17.         If (Arkusz1.Cells(17, 21) < Aopt) And (Arkusz1.Cells(90, 9)) <= 1 Then
  18.             Arkusz4.Cells(bbb, 4) = Arkusz1.Cells(17, 16)
  19.             aaa = aaa + 1
  20.             Arkusz1.Cells(17, 16) = Arkusz4.Cells(1, 4)
  21.         End If
  22.     Next
  23. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement