Advertisement
Guest User

Untitled

a guest
Apr 5th, 2019
154
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Sub rivilisäys()
  2.   Dim r
  3.   r = 1
  4.   Do While Cells(r, 1) <> ""
  5.     Rows(r + 1).Insert
  6.     Cells(r, 2).Cut Cells(r + 1, 1)
  7.     r = r + 2
  8.   Loop
  9. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement