+ Reply to Thread
Results 1 to 3 of 3

Macro Help: Randomizing Teams - "Subscript out of range" error

  1. #1
    Registered User
    Join Date
    05-06-2022
    Location
    California
    MS-Off Ver
    19
    Posts
    2

    Question Macro Help: Randomizing Teams - "Subscript out of range" error

    Good Morning,

    I'm working on a project where I have to create designated teams for office members based on their work schedule. I am working off a Macro template I found in another thread, but it doesnt quite seem to be working. In Column A, starting at A1, I have a list of names (in this case - letters). I'd like to randomly split them up into X amount of groups. I can't seem to find the error in this code. I know there is a function to do this without a macro, but I have a very large data set.

    The error I'm getting is "Subscript out of range". The watches box indicates " People : <Out of context> : Variant/Empty : Sheet2.RandomizeCalls"

    Could anyone offer some assistance?


    Please Login or Register  to view this content.
    Thanks in advance!

  2. #2
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: Macro Help: Randomizing Teams - "Subscript out of range" error

    Ignore - not sure what is happening. I've run it with no problem with the code in the worksheet class.
    Last edited by cytop; 05-06-2022 at 02:36 PM.

  3. #3
    Registered User
    Join Date
    05-06-2022
    Location
    California
    MS-Off Ver
    19
    Posts
    2

    Re: Macro Help: Randomizing Teams - "Subscript out of range" error

    So if I'm understanding you correctly, it's working? What output are you recieving?

+ 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] Why my code is producing Error "SUBSCRIPT OUT OF RANGE" While using variant arrays?
    By Asad Mir in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-20-2020, 10:22 AM
  2. "Runtime error '9': subscript out of range" when running UserForm
    By Niccii in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-23-2019, 04:39 PM
  3. [SOLVED] Unusual "subscript out of range error" on userform initialise
    By Sc0ut in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-31-2015, 06:49 PM
  4. Breaking out Comma Delimited Fields - VBA Error - "Subscript out of Range"
    By sev979 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-13-2014, 09:55 AM
  5. Error msgs: "Object varible or with block variable not set"; "subscript out of range"
    By menyanthe in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-26-2009, 04:58 PM
  6. [SOLVED] "Subscript out of range" error for: Workbooks("Test1.xls").Save
    By Just12341234 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-17-2005, 11:05 AM
  7. FileCopy Command Giving "Subscript Out of Range" Error Message
    By Jim Hagan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-15-2005, 02:05 PM

Tags for this Thread

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