There might be a better way to handle this, but...
For reasons unknown, Excel every once in a while chooses to run a specific one of my functions with no understandable reason. I very likely have named it something that should be a reserved word, and I will be testing that soon, but for the time being I would like to get to understand LIKE better.
Whenever Excel runs the function that should not run it assigns one of four numbers to the first parameter (LTerm), either:
26
38
50
62
(Yes, I noticed the interval of 12)
What I want to learn, which hopefully I will remember but only use briefly, is to write a line like:
If LTerm LIKE "26, 38, 50, 62" Then Exit Function
But apparently a comma isn't the key, and when I just tried to experiment without the spaces (but retaining the comma) Excel refused to divert to my function (Which, by the way, is named LsRate).
So, would one of you fine folks clue me onto the syntax I should be using if this is indeed possible?
Thank-you much!!!
Bookmarks