Some Help with a loop

[ilya2004]

Hi folks,

I have a loop tests to see if a cell matches a value within an array. The code is as follows:

 Function MultiCalc(MyArray As String, MyRange As Range, Cnt As Integer)
     Dim MyCell As Range
     For Each MyCell In MyRange
     MyText= MyCell.Text
     For n = 1 To Cnt
     If MyArray(n) = MyText Then
     MultiCalc = True ' "Next" here
     End If
    Next
 End Function

In order to save time, I would like the loop to quit as soon it finds a match so I would like to put a "next" where I have it marked in the comment. That is to say, "Once you have found a match, go on to the next cell". If I were to put a "next" there, I get the error "Next without For". Any ideas?

-Ilya

 

[wigi]

MultiCalc = True : Exit Function

 

[shg]

What is the function supposed to do? MyArray is not declared as an array in the signature, so it won't compile, and if you did, you couldn't pass a string array to a UDF.

 

[ilya2004]

What is the function supposed to do? MyArray is not declared as an array in the signature, so it won't compile, and if you did, you couldn't pass a string array to a UDF.

Thanks, I'll try that.

In this case what you said should work, but what would happen if I have other code in the function that I would like to keep running, I only want to exit the loop?

 

[ilya2004]

Oh, thanks for letting me know. Will this work as a module? I am just trying be able to test a bunch of cells if they equal any of the values in a defined array.

 

[wigi]

Thanks, I'll try that.

In this case what you said should work, but what would happen if I have other code in the function that I would like to keep running, I only want to exit the loop?

Exit For

Did you check the help files?

 

[ilya2004]

Just doin my best to learn this as I go along. Thanks for you help!

 

[Rick Rothstein]

Oh, thanks for letting me know. Will this work as a module? I am just trying be able to test a bunch of cells if they equal any of the values in a defined array.

You should really quote something from the message you are answering (when there is more than one possibility) so we know for sure who your message is responding to.

Anyway, we can help you, but our problem in trying to do so is in knowing what you are actually trying to do or accomplish. My question is... what do you mean by "defined array"? Is the array you are trying to pass into this function really a String array? In other words, how is it declared in the code you are calling this function from and how did you populate that array?