Advertisement
Guest User

Untitled

a guest
Jan 23rd, 2017
98
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.21 KB | None | 0 0
  1. Sub SelectionToArray()
  2. Dim arrSelection() As String
  3. Dim i As Integer
  4.  
  5. i = 0
  6. ReDim arrSelection(i)
  7.  
  8. For Each c In Selection
  9. arrSelection(i) = c.Value
  10. i = i + 1
  11. ReDim Preserve arrSelection(i)
  12. Next c
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement