Type Mismatch Errors...

I keep getting type mismatch errors here, and I'm not sure why...

Please Login or Register  to view this content.

g is declared as a long for no good reason, but I left it that way. It's sent to this function ByVal. AutoAssign is a function that returns a long-type number from the Test.xls workbook. I don't understand why I'm getting an error at the first call of AutoAssign. It's telling me there's a type mismatch with y, in the function call.

Any suggestions?

Try passing your variable to AutoAssign simply as y rather than ByVal y

AutoAssign(y)

HTH

Hi

I'm pretty sure you only use the byval when you are declaring a function / sub. So remove it from the function call and see how you go.


rylo

I figured it out... the function AutoAssign takes a Long type variable, and the declaration of y wasn't explicit. Once I declared y as Long it worked again.

Thanks for the suggestions!