+ Reply to Thread
Results 1 to 4 of 4

New to VBA, Shuffle Words

  1. #1
    Registered User
    Join Date
    10-23-2013
    Location
    Essex
    MS-Off Ver
    Excel 2007
    Posts
    3

    New to VBA, Shuffle Words

    Hi, i'm a total newcomer to vba and i'm wondering how I could randomly shuffle a word. Iv been set a task whereby words, lists etc need shuffling. I have kind of managed to shuffle the lists but i'm struggling with random re-arrangement of words contained within individual cells (in sheet 2) and then performing the shuffle before re-writing them back into sheet 1. I understand the concept of what i'm meant to do, but just unable to successfully create a piece of working code.

    Any help in this matter would be greatly appreciated!!

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: New to VBA, Shuffle Words

    Code is overkill for this.

    In an adjacent column, enter =rand() and copy down. Then sort both columns by that column.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    10-23-2013
    Location
    Essex
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: New to VBA, Shuffle Words

    Cheers, yeah I appreciate that it can be done far more simply, but the task requires the use of vba and using some sort of anagram function. Also might not have made it very clear but each word that needs re-arranging is contained within 1 cell, i.e. Happy is in cell 1,1 Sad cell 2,1 etc etc

  4. #4
    Registered User
    Join Date
    10-23-2013
    Location
    Essex
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: New to VBA, Shuffle Words

    Anyone else?
    Last edited by SteelMessiah; 10-23-2013 at 05:34 PM.

+ 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] Shuffle Right
    By keen2xl in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-15-2013, 01:40 AM
  2. Mix/shuffle cells around
    By kiapiggy in forum Excel General
    Replies: 4
    Last Post: 11-07-2011, 09:31 AM
  3. Excel 2007 : How to shuffle words in a row?
    By emil9216 in forum Excel General
    Replies: 9
    Last Post: 10-24-2011, 02:16 PM
  4. Excel 2007 : How to shuffle list of words in a column?
    By emil9216 in forum Excel General
    Replies: 5
    Last Post: 10-16-2011, 11:39 AM
  5. Shuffle the cells!
    By M H in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-02-2005, 04:05 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