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:
The Boolean Function is:Please Login or Register to view this content.
Thanks for any help you can give me.Please Login or Register to view this content.
Bookmarks