Load Selection Range (Individual Cell Addresses) Into Array

big_half

New member
Joined
Dec 18, 2014
Messages
1
Reaction score
0
Points
0
I would like create an array that hold the name of each cell address in a selected range. For example Cells A1:A10 are selected, I would like the array to be vRangeArr(0 = "A1", 1 = "A2" etcetc). I can load the values easily but not each address in the selection. How can I do this?
 
Code:
Sub M_snb()
  for each it in selection
    c00=c00 & " " & it.address
  next

  sn=split(trim(c00))
end sub
 
Back
Top