Guest User

Untitled

a guest
Jun 19th, 2018
101
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.46 KB | None | 0 0
  1. Sub myMacro()
  2.  
  3. Dim a, b, c, i, j, k
  4.  
  5. a = 4
  6. b = 11
  7. c = 50
  8. d = 40
  9.  
  10. For Each j In Worksheets("Sheet1").Range("J" & b & ":J" & (b + d))
  11. For Each i In Worksheets("Sheet1").Range("I" & b & ":I" & (b + d))
  12. If IsEmpty(i.Value) Then
  13. j.Value = IsEmpty(i.Value)
  14. Else
  15. j.Value = Range("I" & a).Value
  16. End If
  17. Next i
  18. Next j
  19.  
  20. End Sub
Add Comment
Please, Sign In to add comment