ref

[speedomes]

Hi fellas, I am using the latest beta version and have the sample sheet getAllTradedVolume() COM function
Things go okay then all of a sudden I get a Run time error (6) overflow error. When I his debug this line is the issue

Cells(r, 29).Value = Round((totalProfit / totalTraded) + 1, 2)

Has anyone had this and if so did you sort it as I have to shut it all down and reload the spreadsheet.
I appreciate any help. By the way I really only have the very basic VB knowledge!
cheers

[speedomes]

Thought I'd mention it mostly happens when clicking on another race

[osknows]

Check that totalTraded<>0 before attempting the calc.

[speedomes]

Thanks for getting back to me. After the error when i hover over the offending line in debug it shows: totalProfit=0 and totalTraded=0
How do I check that totalTraded<>0 before attempting the calc?
Sorry if I sound like a complete newb, I am!

[osknows]

Divide by zero is undefined so it's raising an error. Try replacing the line with

Code: Select all

If totalTraded = 0 Then
    Cells(r, 29).Value = 0
Else
    Cells(r, 29).Value = Round((totalProfit / totalTraded) + 1, 2)
End If

[speedomes]

hi, many thanks. I'll give this a whirl and let you know. all the best,
Mike