+ Reply to Thread
Results 1 to 3 of 3

UDF concatenate randomly chosen cells from range (Horizontal Range)

  1. #1
    Registered User
    Join Date
    11-06-2013
    Location
    Korea
    MS-Off Ver
    Excel 2007
    Posts
    4

    UDF concatenate randomly chosen cells from range (Horizontal Range)

    Hey guys,

    Saw a post about how to create a UDF to concatenate randomly selected cells. It does everything I want BUT the data needs to be Vertical for the UDF to work. My data that needs to be concatenated is all horizontal. Any solutions out there on how to change the code?

    http://www.excelforum.com/excel-prog...ml#post3866545

    Here's a link to the original post.
    Last edited by cheesefry; 10-15-2014 at 03:53 AM.

  2. #2
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: UDF concatenate randomly chosen cells from range (Horizontal Range)

    Try this:
    Please Login or Register  to view this content.
    It will work with any contiguous range, whether one row or one column or multiple rows and columns.
    Remember what the dormouse said
    Feed your head

  3. #3
    Registered User
    Join Date
    11-06-2013
    Location
    Korea
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: UDF concatenate randomly chosen cells from range (Horizontal Range)

    Works like a charm. Thanks mate!

+ 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. UDF concatenate randomly chosen cells from range
    By DannyNYC in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-15-2014, 02:45 AM
  2. [SOLVED] Randomly select 25 cells from a column range ans paste in another workbook.
    By SierraKilo78 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-04-2014, 05:44 PM
  3. Randomly choosing cells from a selected range
    By kjones505 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-19-2009, 12:56 PM
  4. Randomly placing 5 same alphabet in a range of 20 cells. (Random Generating)
    By Excript in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-12-2009, 09:52 PM
  5. Delete Non-Randomly Chosen Rows
    By John in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-11-2005, 10:20 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