ByRef Argument Type Mismatch Error

[ALEXJM]

The error occurs on this line (I know that because my debug statement isn't being reached):

Please Login or Register  to view this content.

The following code is trying to invoke this line (variable ss is defined as an integer):

Please Login or Register  to view this content.

The function is expecting a string which is being passed, and returning an integer so I don't understand why I'm getting the mismatch error.

Any ideas??

[AB33]

use Byval instead
Function strengthSchedule(ByVal team As String) As Integer

[ALEXJM]

Thanks AB33, this appears to have worked.

I still don't understand why though. I realise that I was passing by reference (default) which means that the variable could be altered. But I was still passing a string which was being expected??

[xlnitwit]

Did you declare homeTeam as String somewhere? If not, it was a Variant and therefore the type did not match the required argument type.

[ALEXJM]

I think it was declared as string. Anyway I used byVal so it now works, thx

[ALEXJM]

Pls could someone let me know how I mark this as solved, thx.

[xlnitwit]

It couldn't have been declared as String if you had that error.

Click the Thread Tools dropdown at the top and then Mark thread solved.