[RESOLVED] type mismatch

[Zahida.Laljee]

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???

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.

[Pasvorto]

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

[Zahida.Laljee]

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

[kfcSmitty]

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

[Zahida.Laljee]

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?

[kfcSmitty]

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?

[dglienna]

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

[Zahida.Laljee]

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

[kfcSmitty]

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

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

?

[Zahida.Laljee]

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

zee xxx

[penagate]

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

[penagate]

Or is this what you want?

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

?

[Zahida.Laljee]

thank you very much

[penagate]

No worries, I take it the second one did it

Please mark your thread resolved using the Thread Tools menu.