+ Reply to Thread
Results 1 to 4 of 4

Possibility to use dynamic range while outputting range to specific columns

  1. 07-02-2019, 01:00 AM #1
    jaryszek
    jaryszek is offline
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,946

    Possibility to use dynamic range while outputting range to specific columns

    Hi,

    i am using code from here:

    Please Login or Register  to view this content.
    code from here: https://www.excelforum.com/excel-pro...ml#post5145783

    the last statement: 
    Please Login or Register  to view this content.
    can be populated dynamically?

    Please help,
    Jacek
    Last edited by jaryszek; 07-02-2019 at 01:03 AM.
    Reply With QuoteRegister To Reply
  2. 07-02-2019, 08:35 AM #2
    Fluff13
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,888

    Re: Possibility to use dynamic range while outputting range to specific columns

    Yes it can, you can change it to 
    Please Login or Register  to view this content.
    and populate MyArray in any way you choose
    Reply With QuoteRegister To Reply
  3. 07-02-2019, 09:33 AM #3
    jaryszek
    jaryszek is offline
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,946

    Re: Possibility to use dynamic range while outputting range to specific columns

    thank you !

    Jacek
    Reply With QuoteRegister To Reply
  4. 07-02-2019, 09:40 AM #4
    Fluff13
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,888

    Re: Possibility to use dynamic range while outputting range to specific columns

    You're welcome & thanks for the feedback
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copy specific range selection to msword but why it copies columns not in range?
    By adbasanta in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-11-2016, 03:46 AM
  2. [SOLVED] Dynamic Table Range, Dynamic Columns
    By bimo in forum Excel General
    Replies: 6
    Last Post: 06-24-2013, 08:16 AM
  3. Sum of specific dynamic range
    By jenz_skallemose in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-08-2013, 08:48 AM
  4. Outputting Array into Range
    By awan0126 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-20-2011, 03:37 PM
  5. sorting a dynamic range from smallest to largest and outputting in cells
    By mashoutposse in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-02-2010, 08:23 PM
  6. Finding shortest range from some routes possibility (is it TSP?)
    By lukius in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-17-2010, 07:56 PM
  7. Using specific columns of a dynamic range
    By Darren in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-02-2006, 06:30 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1