Using a Boolean function within an If statement: Argument not optional error message

Hello

I'm sure this is going to be a huge derp moment (total programming novice here), but I have a question about how to properly nest a Boolean within an If statement (... within an If, within a Loop, within a Function, heh).

What I have written here looks (to my eyes) exactly like the 5 or 6 examples I was able to find via google, but when I step through my Sub it returns a "Compile error: Argument not optional" message box whilst highlighting the text I've written in red below. Is the If statement wrongly constructed, or is it the Boolean Function that's got an error?

The overall goal of this particular function is to copy specific cells in a row from sheet1 to sheet3, but only if the values of two of those cells (SectionNumber and AudCrit) are not already seen -- together in the same row -- in columns B and C on sheet3.

The Larger Function:

Please Login or Register  to view this content.

The Boolean Function is:

Please Login or Register  to view this content.

Thanks for any help you can give me.

I'm not sure but I don't think you need the second ByVal beside AudCrit. Also, you should declare the type of variable that AudCrit is in that line.

elfsprin,

That error happens when a function is missing an argument to complete correctly. The function you created requires three arguments: SectionNumber, AudCrit, and OccupiedRow. In the line that's giving you an error, you have only fed the function 2 arguments:

Originally Posted by elfsprin

Please Login or Register  to view this content.

1. I am not able to duplicate that behavior. When run a sub that calls a function which uses another function, and then step through the code using F8, I am taken to each function as expected. This happens regardless of whether the sub, function, and secondary function are in the same module or all in different modules.


2. Its because when you use If ... Then ... on the same line, it does not need an End If. And you use that on this line:

Please Login or Register  to view this content.