Results 1 to 10 of 10

Extract 1 row of an array into a range of cells

Threaded View

  1. #1
    Valued Forum Contributor luv2glyd's Avatar
    Join Date
    07-13-2008
    Location
    Seattle, WA, US
    MS-Off Ver
    Excel 2010
    Posts
    679

    Extract 1 row of an array into a range of cells

    If I have an array defined like this:

    myMatrix = Range("A7:E100").Value
    how can I extract the contents of the 3rd row into cells A3:E3 without a loop, similarly to this:

    Range("A3:E3").Value = myMatrix(3rd row of matrix)
    I know I can do this:
    Range("A3").Value = myMatrix(1,1)
    for example so just looking to do the same thing but get the row out into a range of cells with just one shot vs. a single element into a single cell.
    Last edited by luv2glyd; 12-02-2015 at 12:16 AM.
    You either quit or become really good at it. There are no other choices.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] What is wrong with this code? (Extract Row from 2D array to 1D array)
    By mc84excel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-10-2013, 07:17 AM
  2. Replies: 8
    Last Post: 04-12-2013, 10:54 AM
  3. How to extract duplicate from the range of cells and gives its count?
    By nagesh_mvj in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 02-20-2012, 02:48 PM
  4. Replies: 3
    Last Post: 11-24-2011, 06:11 AM
  5. Help with using a range of cells as an array
    By cmb503683 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-18-2011, 01:34 PM
  6. Copying an array to a range of cells
    By SDruley in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-09-2010, 06:35 PM
  7. extract data from a range of cells in rows or columns when a date.
    By Dartyon in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-24-2005, 07:06 PM

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