Sample sheet get traded volumn COM function

[Roadhouse]

Hi Gary a few errors keep coming up with this sample sheet I downloaded I've set up the com one of the errors was

Run time error (6) overflow error. When I his debug this line is the issue
Cells(r, 29).Value = Round((totalProfit / totalTraded) + 1, 2)

[Captain Sensible]

I'd guess there's no error trapping on the sheet and there are empty variables.

[Roadhouse]

Hi, Captain do you have any suggestions on how it could be fixed ?

[Captain Sensible]

I don't use the sheet so no idea what it's doing, I can only guess totalProfit and totalTraded are being sent as 0 so totalProfit / totalTraded is throwing the error.

You could always bypass it with an IF

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