Results 1 to 2 of 2

Thread: Load Selection Range (Individual Cell Addresses) Into Array

  1. #1

    Load Selection Range (Individual Cell Addresses) Into Array



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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?

  2. #2
    Conjurer snb's Avatar
    Join Date
    May 2013
    Posts
    374
    Articles
    0
    Excel Version
    2020
    Code:
    Sub M_snb()
      for each it in selection
        c00=c00 & " " & it.address
      next
    
      sn=split(trim(c00))
    end sub

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •