Advertisement
Guest User

Untitled

a guest
Apr 26th, 2017
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Sub var12_1()
  2.     Set d = Range("A1").CurrentRegion
  3.     m = d.Rows.Count
  4.     n = d.Columns.Count
  5.     Dim a As Single, b As Single
  6.     a = InputBox("Ââåäèòå ÷èñëî 'à'")
  7.     b = InputBox("Ââåäèòå ÷èñëî 'b' (áîëüøåå, ÷åì 'a')")
  8.    
  9.     copyRows = 0
  10.    
  11.     If a > b Then MsgBox ("a áîëüøå b"): Exit Sub
  12.    
  13.     For i = 1 To m
  14.         pravilnieZnacheniya = True
  15.         For j = 1 To n
  16.             If (d.Cells(i, j) < a) Or (d.Cells(i, j) > b) Then pravilnieZnacheniya = False
  17.         Next j
  18.        
  19.         If pravilnieZnacheniya = True Then
  20.             copyRows = copyRows + 1
  21.             For j = 1 To n
  22.                 d.Cells(copyRows, n + 1 + j) = d.Cells(i, j)
  23.             Next j
  24.         End If
  25.     Next i
  26.    
  27.    
  28. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement