An example of the problem is that let's say the fourth statement (If Code4 = Maincode And Class4 < 48 Or Class4 > 54 Then
Cantdisclose = Class4) is the first statement to satisfy all conditionals. I want excel to return Cantdisclose as Class4. However, Excel continues reading the UDF and returns the last true if statement
Full Code Below:
Any way to fix this?Please Login or Register to view this content.
Thanks
Bookmarks