Difficulty With User Defined Functions (UDF) - Case Statements for String & Int

Please Login or Register  to view this content.

One possible problem is that the function is an integer, but getting assigned a string by the code... your dim statements are commented out, but you'd have trouble trying to Dim STED as String when the function is already named STED and declared as an Integer.
Additionally this is not how Select Case works... you are selecting the Case Country_test but then not actually checking for a value, instead checking other conditions...

Here is a possible alternative:

Please Login or Register  to view this content.

do note that if count_test is 1 or 29 or 30 or 69 then they are not included... you may want the => =< operators instead... but wasn't sure that is true.

Thank you both for your help, I have gotten it working a little.

Another question:

What is the correct syntax for determining if a specific cell in the row has a value? I will be adding another check under the 4th case(ie. Number is between 30-77 (if cell H1 is: yes - Group C; no = group D)

Please Login or Register  to view this content.

If you are going to test another value, then it should be passed as an argument to the function. Otherwise, Excel sees no dependency and won't recalculate the function if it changes.

I'm saying a function should receive all its arguments.

You wouldn't write a function that calculates the sum of one number passed to it plus some other random cell it finds on the worksheet, right?

If requirement is a cell, it should be of type Range, not integer. IsEmpty is a fine test, but it applies only to data type Variant (which is what a cell contains).