Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Sub SelectionToArray()
- Dim arrSelection() As String
- Dim i As Integer
- i = 0
- ReDim arrSelection(i)
- For Each c In Selection
- arrSelection(i) = c.Value
- i = i + 1
- ReDim Preserve arrSelection(i)
- Next c
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement