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 =)
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,940
Reaction score
0
Points
36
Excel Version(s)
O365
I think we need to see the other procedures, especially oReport.RaceAnalysis
 

Ken Puls

Administrator
Staff member
Joined
Mar 13, 2011
Messages
2,521
Reaction score
6
Points
38
Location
Nanaimo, BC, Canada
Website
www.excelguru.ca
Excel Version(s)
Excel Office 365 Insider
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.
 
Top