Advertisement
Guest User

Untitled

a guest
Jul 25th, 2017
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.68 KB | None | 0 0
  1. Sub CF_Macro()
  2.  
  3. CF_Macro Macro
  4.  
  5. Sub SpitValues()
  6.  
  7. Dim wsInput As Worksheet
  8. Set wsInput = Worksheets("Repline Input")
  9.  
  10. Dim wsSummary As Worksheet
  11. Set wsSummary = Worksheets("Summary")
  12.  
  13. With wsInput
  14.  
  15. .Range("G11").Resize(10, 1).Value = "FALSE"
  16.  
  17. Dim rCell As Range
  18. For Each rCell In .Range("G11").Resize(10, 1)
  19.  
  20. rCell.Value = "TRUE"
  21.  
  22. DoEvents
  23. 'Application.Wait (Now + TimeValue("0:00:05"))
  24. wsSummary.Range("b13:b16").Copy
  25. wsSummary.Range("z1").Select
  26. Selection.End(xlToLeft).Offset(ColumnOffset:=1).PasteSpecial xlPasteValues
  27. rCell.Value = "FALSE"
  28.  
  29. Next
  30.  
  31. End With
  32.  
  33. 1 TRUE
  34. 2 FALSE
  35. 3 FALSE
  36. 4 FALSE
  37. 1 TRUE
  38. 2 FALSE
  39. 3 FALSE
  40. 4 FALSE
  41. 1 TRUE
  42. 2 FALSE
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement