+ Reply to Thread
Results 1 to 4 of 4

Need help on some Homework in Excel vba. x-Posted

  1. #1
    Registered User
    Join Date
    07-22-2015
    Location
    moon
    MS-Off Ver
    2013
    Posts
    2

    Need help on some Homework in Excel vba. x-Posted

    I'm stuck and would like a hand on putting me in the right direction for parallel arrays.

    Question is " use parallel arrays to load the Last name and row number or first cell in the row. Sort both arrays based on the Last name array (every time a last name is moved also move its corresponding row number in its array)"

    Here is what i got so far.

    UserForm

    Please Login or Register  to view this content.
    What I got for a Array which is wrong.

    Please Login or Register  to view this content.
    Like I said earlier I just want some help on being pointed in the right direction.

    Thanks in advance.

    Other site i posted on : Click Here!

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    25,423

    Re: Need help on some Homework in Excel vba. x-Posted

    You don't seem to be setting the variable Continue to be True at any point.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    07-22-2015
    Location
    moon
    MS-Off Ver
    2013
    Posts
    2

    Re: Need help on some Homework in Excel vba. x-Posted

    Quote Originally Posted by Pete_UK View Post
    You don't seem to be setting the variable Continue to be True at any point.

    Hope this helps.

    Pete
    I forgot lol but I did now but it still does not work.

  4. #4
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,962

    Re: Need help on some Homework in Excel vba. x-Posted

    Why did you put Continue = False inside the Do..loop?
    You should enter the loop with Continue set to True and change it to False somewhere () inside the loop based on some condition...
    Ben Van Johnson

+ 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. Replies: 2
    Last Post: 03-07-2015, 08:17 PM
  2. Replies: 1
    Last Post: 03-06-2015, 09:54 PM
  3. Replies: 0
    Last Post: 03-06-2015, 03:07 PM
  4. Replies: 0
    Last Post: 03-06-2015, 12:43 PM
  5. Homework help on Excel?
    By insomniousfire in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-15-2012, 11:25 AM
  6. How to tell if a student is cheating in Excel homework
    By twobecontinued in forum Excel General
    Replies: 6
    Last Post: 09-16-2012, 10:41 PM
  7. Advanced Excel homework, HELP!
    By jsmith161 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-17-2011, 05:40 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