+ Reply to Thread
Results 1 to 3 of 3

Paste part of an array

  1. #1
    Forum Contributor
    Join Date
    12-01-2007
    Location
    USA-North Carolina
    MS-Off Ver
    MS Office 2016
    Posts
    2,662

    Paste part of an array

    Hi,

    I have a dictionary of values. Dictionary is called "dic_DtCln360_subj". I "extract" the values from the dictionary using this approach:



    Please Login or Register  to view this content.



    My problem is that i want the "Non conformant data" to be pasted not in col-E but some other column say "Z". I do want Country, Site Mnemonic, Study, and Subject Number to be pasted into cols A, B, C, and D..........as i said i just want the "Non-conformant data" to be pasted in col-Z.

    So i have this array " DtCln360_paste_array" which is a variant array organized like this (1 to x, 1 to 5)

    where x is the number of elements/rows plus header and "5" are the cols Country, Site Mnemonic, Study, Subject Number and Non Conformant data.

    Any ideas on how to solve this problem?

  2. #2
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Paste part of an array

    DtCln360_paste_array(1, 26) = "Non conformant data"
    You also need to increase the out put array in to

    ReDim DtCln360_paste_array(1 To dic_DtCln360_subj.Count, 1 To 26) As Variant

  3. #3
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Paste part of an array

    Untested.
    Please Login or Register  to view this content.

+ 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. vba array - extracting part of an array to worksheet
    By Kramxel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-10-2015, 01:19 PM
  2. Can I make the row lookup array/range part in an array formula variable?
    By OLLY-7 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-18-2014, 09:06 AM
  3. Replies: 0
    Last Post: 10-29-2013, 09:38 AM
  4. Does filling part of an array from a range re-dimension the array?
    By barryleajo in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-04-2011, 10:09 AM
  5. Transferring part of a large array to smaller array
    By Xrull in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-26-2011, 09:39 AM
  6. search for a part of string within an array of strings from another array list
    By jdonohue in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-12-2011, 01:32 PM
  7. using excel array functions on part of array
    By chewwy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-29-2009, 07:19 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