Advertisement
Guest User

Untitled

a guest
Jun 16th, 2019
61
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.29 KB | None | 0 0
  1. Sub merge()
  2. Dim i As Integer
  3. Dim i2 As Integer
  4. Dim i3 As Integer
  5. i = Range("B1")
  6. i2 = Range("B2")
  7. i3 = Range("B3")
  8. Range("A1:A" & i).merge
  9. Range("A" & (i + 1) & ":A" & (i + i2)).merge
  10. Range("A" & (i + i2 + 1) & ":A" & (i + i2 + i3)).merge
  11. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement