Conditional Statements & Nested If/Then in VBA

I am trying to write a function or sub which passes in 3 variables from the worksheet and returns a number 0-3 based on conditional statements (nested If/then). However, the func returns ‘0’ for all cases. Using breaks in the module, I can see this is because, while the variables have been passed in (UpIso, Con, DIso), the function (isolation) =’empty’

My code is below. Any help is appreciated. Thanks

Please Login or Register  to view this content.

I strongly recommend to everyone that they declare variables. Doing so prevents a lot of bugs and runtime errors.

If you do this you will find that you have variables Y, N, FD, Station, and NA which are undeclared, and also unset. Therefore they are all 0. I can't tell for sure without seeing your file but I assume you are looking for character strings.

Please Login or Register  to view this content.

Also, when you post code, use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

Thanks for comments on general formatting, I'll keep that in mind. I've declared the variables from the worksheet as variant, but still have the same problem. Here is the new code:

Please Login or Register  to view this content.

What happens when you step through the code? does it drop out anywhere or does it perform as you would expect but still give the wrong answer?

Originally Posted by jjjhs12

I've declared the variables from the worksheet as variant, but still have the same problem.

You missed my point. Those values need to be in quotes, not variables. I provided the code. You seem to have ignored it.

I suggested Option Explicit because if you had used it, you would have gotten compiler errors and realized you needed quotes instead of variables.