Joksa

Untitled

Jun 9th, 2020
759
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. ----------------------------------------------------------------------------------------------------------------------------------------------------------
  2. ----------------------------------------------------------------------------------------------------------------------------------------------------------
  3. Sub Macro998()
  4. '
  5. ' Macro2 Macro
  6.    Dim cell As Range
  7.    
  8.     Cells.Find(What:="201", After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _
  9.         xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _
  10.         , SearchFormat:=False).Activate
  11.     For Each cell In Cells
  12.         Range(ActiveCell.Offset(0, 1), ActiveCell.Offset(0, 1)).Select
  13.         If ActiveCell.HasFormula = True Then
  14.             MsgBox "IMA FORMULU END FOR LOOP"
  15.             Exit For
  16.         End If
  17.         ActiveCell.Value = "=" + Range(ActiveCell.Offset(-1, 0), ActiveCell.Offset(-1, 0)).AddressLocal() + "*11.5"
  18.         Range(ActiveCell.Offset(0, -1), ActiveCell.Offset(0, -1)).Select
  19.         If ActiveCell.HasFormula = False Then
  20.             Cells.FindNext(After:=ActiveCell).Activate
  21.         End If
  22.     Next cell
  23. End Sub
  24. ----------------------------------------------------------------------------------------------------------------------------------------------------------
  25. ----------------------------------------------------------------------------------------------------------------------------------------------------------
Add Comment
Please, Sign In to add comment