Guest User

Untitled

a guest
May 9th, 2020
49
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.42 KB | None | 0 0
  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. ----------------------------------------------------------------------------------------------------------------------------------------------------------
Advertisement
Add Comment
Please, Sign In to add comment