+ Reply to Thread
Results 1 to 3 of 3

Write values from selection into 1D array

  1. #1
    Registered User
    Join Date
    01-12-2015
    Location
    PL
    MS-Off Ver
    2016
    Posts
    29

    Write values from selection into 1D array

    Hi,
    How can I write values from selected range into an 1D array?
    This is my code so far:
    Please Login or Register  to view this content.
    The problem is that this code writes into my array only value from the first selected cell. Can you advise how to write all values from filtered range into an array?

    Thanks in advance
    Regards

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Write values from selection into 1D array

    The below link will help you, I think.

    https://www.thesmallman.com/excel-autofilter-to-array


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Registered User
    Join Date
    01-12-2015
    Location
    PL
    MS-Off Ver
    2016
    Posts
    29

    Re: Write values from selection into 1D array

    I used the copy-paste method and saved individual ranges as arrays.
    Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] write values next to a column of times which fall within timeranges of an array
    By jrtaylor in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-30-2019, 02:13 PM
  2. [SOLVED] Populate Dynamic Array from Cell Values and write to Dynamic Range
    By TFiske in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-22-2018, 09:09 AM
  3. How to read/write values from/to array vba
    By XLSlearning in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 02-23-2018, 01:13 PM
  4. Replies: 4
    Last Post: 02-22-2012, 08:58 AM
  5. write column vector of 2D array into 1 D array
    By twd000 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-22-2010, 06:01 PM
  6. [SOLVED] Write 1st and 2nd dimension array values to cells
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-28-2006, 07:20 PM
  7. Write selection
    By starfighter61 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-12-2005, 02:05 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1