Advertisement
Guest User

Untitled

a guest
Jun 16th, 2019
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.53 KB | None | 0 0
  1. Option Explicit
  2.  
  3. Sub test()
  4.  
  5. Dim LastRow As Long, i As Long
  6.  
  7. 'Set you sheet
  8. With ThisWorkbook.Worksheets("Sheet1")
  9.  
  10. LastRow = .Cells(.Rows.Count, "A").End(xlUp).Row
  11.  
  12. 'Start from row 2
  13. For i = 2 To LastRow
  14.  
  15. If Not IsEmpty(.Range("A" & i).Value) Then
  16.  
  17. .Range("B" & i - 1).Value = .Range("B" & i).Value + .Range("B" & i - 1).Value
  18.  
  19. Else
  20.  
  21. .Range("B" & i + 1).Value = .Range("B" & i).Value
  22.  
  23. End If
  24.  
  25. Next i
  26.  
  27. End With
  28.  
  29. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement