Help needed Run-Time Error 13: Type missmach

nomedia

New member
Joined
Aug 2, 2011
Messages
1
Reaction score
0
Points
0
Hi I`m useing Excel 2010 I have a macro which gives me Run-Time Error 13: Type missmach every time I try to lounch it. Can anybody help me? An error code line is folowing:


Private Sub ProcessRace(nIndexStart As Long, nIndexEnd As Long, nCols As Long, bIsCreateCSVReport As Boolean, asRaces() As String, sFileName As String)

oReport.RaceAnalysis nIndexStart, nIndexEnd, nCols, bIsCreateCSVReport, asRaces()

End Sub



Here is also link to screenshot of error line
http://www.bildites.lv/images/zt9cd51b8wh69san7qo.jpg

Thanks for in advance =)
 
I think we need to see the other procedures, especially oReport.RaceAnalysis
 
I agree with Bob, but it may also be helpful to see the routine that calls ProcessRace. I wonder if you were to specially typecast the variables you're feeding it if the error would happen there. I.e. nIndexStart = CLng(myinput) would make sure you've actually passed it Long data and not an Integer or something.
 
Back
Top