[RESOLVED] type mismatch

Im not sure if this is the correct place to post this query but i hope so.

Why do i get a type mismatch Run-time error 13, for the following piece of code???

VB Code:

returns(a) = "=Average(loser["& a &" "& b &"]:loser ["& a &" "& b+10 &"])"

If returns(a) and loser(a, b) are defined as Single then why is there a mismatch?

Any help would be most appreciated.

You have a string on ther right side of the equation, but there is no quote to close it

that was a typo in my question there is quotation to close it - but thanks
:(

Uhh, seems to me you're assigning a string to a single then

I dont exactly understand what that line of code is trying to do though

Loser() contains values that need to be used to calculate the average returns.

so although it is entering a string into the array component of returns(a) it is supposed to enter the average value of loser(a,b) and loser(a, b+1). Does that make any sense? :D

not exactly to me :), however, simply looking at

"=Average()" leads me to believe it is a string..the average function is meant to be used with single values is it not?

Are you using Excel? It required cell reference as A1, and loser(1,1) won't work.

but the value is contained in loser array component(1,1)?!?!?

im just gonna remove the strings..is this what you want?

returns(a) = Average(loser[a,b]:loser [a,b+10])

?

but that doesn't compile because a list seperator or ) needed?

zee xxx

This is Excel isn't it? You are using the : symbol to indicate a range?

Or is this what you want?

VB Code:

Dim i As Long
Dim sngAvg As Single
For i = b To (b + 10)
    sngAvg = sngAvg + Loser(a, i)
Next i
sngAvg = sngAvg / 11
Returns(a) = sngAvg

?

:D thank you very much

No worries, I take it the second one did it :)

Please mark your thread resolved using the Thread Tools menu.