Contact US

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Help with WHILE loops

Help with WHILE loops

Help with WHILE loops

I am very inexperienced with while loops.  I am trying to write a loop that checks all the answers in a vector and if they are "OK" then it outputs "OK".  I keep getting an "array index invalid for this array problem".  I have written a simplified example of this problem to post here.  If someone could please take a look and explain what I am doing wrong it would be greatly appreciated.  I believe it is due to my lack of knowledge/experience with using a while loop altogether.  Thank you

RE: Help with WHILE loops

I don't see where you assign any value to "vec".  If I make start and end different from each other the error goes away and veclocation has a value in the output (the value is the next cell after the end of the while).


RE: Help with WHILE loops

well vec is not defined because I am using it as a function and therefore it isnt required to be defined.  The origin has something to do with this problem as if i set the origin to zero in worksheet preferences both work.  I think I have some sort of misunderstanding of the array indexing that I was hoping someone could clarify

RE: Help with WHILE loops

IRstuff thank you.  I realize what is wrong now.  To fix it I am guessing there needs to be an otherwise statement added to the IF statement but I can't seem to get that to work.  Any ideas of what i can do

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login


Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close