Unwanted lay bets

[Johnedale]

I've been using a modified version of the BA spreadsheet to record pre-off racing data for a few months now. One of the things my VBA code does is place a £2.01 lay bet at 1.01 ten minutes before the off. This is just so I have an easy way to check that the code is running ok while I'm at work.

Yesterday a power cut took out my router for a few minutes from about 17.53 to 17.57. I happened to be using guardian at the time, and when the connection came back I suddenly found that I had 455 unmatched lay bets at 1.01 in the 18.05 at Newton Abbot.

As far as I can see, the code responsible for placing the lay bet only executed once. It also adds an extra sheet to a workbook so would be easy to see if it had run too many times.

According to my betting history on the BF site, the bets were placed between 17.55 and 17.57, which was when I had no connection. I've tried to replicate the problem this morning but no success. The code I use to place the bets is :

tw.Worksheets(RaceNum).Cells(9, "L") = ""
tw.Worksheets(RaceNum).Cells(9, "M") = 1.01
tw.Worksheets(RaceNum).Cells(9, "N") = 2.01
tw.Worksheets(RaceNum).Cells(9, "O") = ""
tw.Worksheets(RaceNum).Cells(9, "L") = "LAY"

Anyone have any idea what might have happened?